listing records from 2 database tables even if there are no values inone table

[shama8]

I hope that this makes sense, but as an example:

I have 2 databases. The first one (db1) contains Product Name &
Serial Number. The second (db2) contains Serial Number and Price (but
does not contain all of the records in db1). I want to see ALL
Product Names (from db1) and Prices (from db2), where price is
available. When I link "Serial Number" from each database, I only get
the common results, withe some Product Names eliminated.

How could I get All Product Names and Prices, showing "n/a" (or
something like that) when there is no Price on record?

Any help is greatly appreciated. Thanks!

 

[RAf]

shama

you need to click on the link between the two table in the select query (
design view) and change the joint so that it "contains all the data from db1
table"

regards

raf

 

[Jeff Boyce]

There may be a confusion of terminology here.

Each MS Access .mdb file is considered a "database (db)". Within each .mdb
file there may be multiple "tables". Each table holds fields (or columns).

Are your [Product Name] and [Serial Number] the names of fields or the names
of tables or the names of databases?

Regards

Jeff Boyce
Microsoft Office/Access MVP