List unrelated items

[Guest]

I have two tables that have a linked field with many of the same part numbers. One table is items that are good, and the other has items in which many are good, but many are expired. What command can I put in the query to only show the items in the combined table that are listed in the good table?

 

[[MVP] S.Clark]

Linking the two tables with an Inner Join should do it.

Select * table1 INNER JOIN table2 on table1.id = table2.id


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

I have two tables that have a linked field with many of the same part

numbers. One table is items that are good, and the other has items in which
many are good, but many are expired. What command can I put in the query to
only show the items in the combined table that are listed in the good table?