alisonthom
asked on
MS Access query
Hi,
I would be very grateful if someone could help me with the following.
I have 2 tables that have the same number of records and some fields are the same.
I would like to produce a query that retrieves all the data from the 2nd table and adds the records for 2 fields from the 1st table.
Many thanks in advance
Alison
I would be very grateful if someone could help me with the following.
I have 2 tables that have the same number of records and some fields are the same.
I would like to produce a query that retrieves all the data from the 2nd table and adds the records for 2 fields from the 1st table.
Many thanks in advance
Alison
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Replace PK with the common column in the above sql
ASKER
Very sorry for the delay in replying.
Thanks so much for your help
Alison
Thanks so much for your help
Alison
ASKER
Yes, there is a common column in both tables. Could you indicate how this would affect the SQL you have suggested?
Many thanks
Alison