MS Access JOIN Query
Posted on 2011-04-25
Good Day Experts
Perhaps you all can assist me as my MS Access query building experience is rather light.
I have three tables that I am working with...InvoiceHeader, InvoiceDetail and Address.
I am interested in getting all of the data fron the InvoiceDetail table for each InvoiceHeader record. InvoiceNumber is the common field between the two tables. In the InvoiceHeader and Address tables, I have a field names StoreNumber. I want to get the address information from the Address table.
Conceptually this seems doable:
1)Get InvoiceDetail records based on InvoiceHeader.InvoiceNumber
2)Get Address records based on InvoiceHeader.StoreNumber
I do ok when not trying to do the Address table. But, I am not sure how to do it to get the address table data.
Any helpful hints or insight is appreciated,