Need an example of a query of how to pull record data from three tables?
Posted on 2006-11-07
I need to write a query that pulls information from three different tables, and joins the information from the three tables into one record.
Each table has one field in common with the others.
That field is RequestID.
From table A I need to pull RequestID, LoadedLOE.
From table B I need to pull RequestID, ReleaseMonth, ReleaseYear.
From table C I need to pull RequestID, Subline.
The query needs to combine these records into my table D.
Thanks in advance for your time.