How do I make a query from a table within a table?

[ajcollier93]

How do I make a query from a table within a table?



The first table is Products and the second is Inventory Levels. I want to select Product Name

[pbaldy]

Looks like you missed a picture, and maybe some of the question. The short answer is you can't, and most of us never let users directly in tables anyway. They just see forms and reports.

[ajcollier93]

Are you not able to see the picture?

[ajcollier93]

So are you saying that I can not make any queries from this database. Its just a sample database I am using to train with

[pbaldy]

I see one, it looks like another above it didn't work.

No, I'm saying you can't have "a query from a table within a table", though in truth I'm not really sure what you're trying to accomplish.

[ajcollier93]

If you are seeing the correct picture, how would you go about making a query that selects ProductName?

This is how I wrote it but it doesnt recognize the column. It just says enter parameter value.
SELECT ProductName
FROM Products;

[pbaldy]

Like I said, in a table the short answer is you can't . The longer answer is you can using as lookup field, but most of us recommend not using those. Note number 2:

http://www.theaccessweb.com/tencommandments.htm

[isladogs]

I haven't used northwind for several years but it looks as though there is a space in the field name
Try using

SELECT [Product Name] FROM Products;