Display the filed in one table linked to data not exist in other table

[dashagua]

I have two tables "Mfg_Part_Master" and "Order_Master". They are linked by " linked" by manufacturer part#-"MPNNUM" in both tables.
PurchasePrice field is saved in "Order_Master" table.

I need to get a report like this:
MPNNUM PurchasePrice
M111 1.00
M112
M113 2.00

My manager asked for all MPNNUM to be showed on the report even if PurchasePrice is not in the "Order_Master" table.For example M112 should be there. But in my report, M112 is missing. How can I show the M112 out?

 

[Turkbear]

Hi,
use a Left Outer Join between
Mfg_Part_Master
and
Order_Master





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[dashagua]

Thanks for the response. But I am sorry, Turk, I don't quite understand. Is it a fomula of Selection Expert or someyhing elase?

 

[dashagua]

OK, I got it. And it worked. Thanks.

 

[Turkbear]

Hi,
Glad to help..I maybe should have specified that you use Database Expert-Links tab to right-click and select the type of link option...





To Paraphrase:"The Help you get is proportional to the Help you give.."