Howto view fields via query from table which have id's to other tables

D

Danny

I have a simple table of a serialnumber, product and 'product used by'
fields. The product ussed by field has an id to another table of
users. I want to query all serialnumbers, products and update which
user used them. How do I view all fields?
Thank you
 
A

Arvin Meyer [MVP]

Use a Join on the 2 tables on the "product used by" field. Sort by the
username or ID to get the same ones together. Something like:

SELECT SerialNumber, Product, LastName, FirstName
FROM Products INNER JOIN Orders ON Users.EmployeeID = Products.EmployeeID
ORDER BY EmployeeID;
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top