Matching (find all in common) two tables of titles

[EDS]

Hi,

I have two tables of titles (DVDs and CDs). Each table has a price associated with each title in an adjacent column. I would like to match the titles between them and compare prices. Any help would be greatly appreciated. Thanks. EDS

 

[mtairhead]

It sounds like you just need a query with two tables, and a relationship set between the title fields. That would return for you any titles in your CD table that also exist in your DVD table, as well as their respected prices.

If that's what you want, all the info you need will be under the help article entitled "About joining tables or queries in a query."

Andrew

 

[Rich]

Why do you have two tables when one will do?