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

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


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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


"Danny" wrote in message
news:1131961888.154387.94940@o13g2000cwo.googlegro ups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7347-howto-view-fields-via-query-table.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7347
> 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
>