Hi,
I have 2 tables:
On table 1, I have
Id Type Date Details
-- ---- ---- -------
1 A Aug02 ABC
2 B Aug02 CDE
On table 2, I have the info. for updated entry
Id Type Date Details
-- ---- ---- -------
1 A Oct02 CDE
What I want is, a merged table with;
Id Type Date Details
-- ---- ---- -------
1 A Oct02 ABC
2 B Aug02 CDE
How could I do that?
I tried to creat a relation in Access and then use Inner join in the SQL query, however, I could never got the entries I want.
Please shed some light on this!
Thanks!!!!
ciel220
I have 2 tables:
On table 1, I have
Id Type Date Details
-- ---- ---- -------
1 A Aug02 ABC
2 B Aug02 CDE
On table 2, I have the info. for updated entry
Id Type Date Details
-- ---- ---- -------
1 A Oct02 CDE
What I want is, a merged table with;
Id Type Date Details
-- ---- ---- -------
1 A Oct02 ABC
2 B Aug02 CDE
How could I do that?
I tried to creat a relation in Access and then use Inner join in the SQL query, however, I could never got the entries I want.
Please shed some light on this!
Thanks!!!!
ciel220