Joining to tables together in a query

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

I have 2 tables as below. I would like to make one table
as I will describe

Table 1 [Contacts]{ContId}{Name}{Address}
Table 2 [Photos]{ContId}{PhotoName}
This table has upto 6 photos for each {ContId}

I would like to end up with a table or query like this:
{ContId}{Name}{Address}{PhotoName1}{PhotoName2}
{PhotoName3}{PhotoName4}{PhotoName4}{PhotoName6}

I know that this can be done but I do not know how. Have
looked and have not found what I need.

I will appreciate all of the help that you can give me.

Best
Regards
Robert Raley
 
Back
Top