Join two tables

[ScottXe]

I have two tables: products and orders. I would like to query the products only with orders using the product code and/or model number and join up all product and order information for further manipulation. Can someone advise how to set up this query. Thanks.

 

[CJ_London]

one a new query window and select the table you want in the query

If you have set up relationships, the joins will appear. If not, you can create a join by clicking and holding on the field and dragging to the the other field to create a join

here is a link that may help

https://www.youtube.com/watch?v=qceAxjRciXI

 

[pmlee]

If you wanna do it in SQL view:

SELECT *
FROM tblProducts
JOIN tblOrders ON tblProducts.orderNumber = tblOrders.orderNumber