I am trying to learn about MS Query, and how to write SQL statements and return the results to excel.
I would like to link the two tables within excel (see attached) together based on two criteria, to produce one table that has the following headings:
SO Number, Item Number, SO Quantity, Invoice Quantity, Invoice Number.
As each Sales Order (SO) can have multiple Items, I need to create a relationship between the SO number and the Item numbers on both tables. I require the results to display ALL the SO numbers (as there cannot be an invoice without a Sales Order), with a zero value should there be no invoice.
I understand how to open MS Query from excel, it is the SQL Statement I am struggling with.
Also, as a very new user to MS Query, are there any resources online that explains MS Query at a basic level?