running a query with 2 tables

Payal Patel

Registered User.
Local time
Today, 04:58
Joined
Nov 3, 2009
Messages
34
Hi,
I have one bill table and one vendor table. Both tables have the common field "vendor name". I want to retrieve all the rows from the bill table that have the same vendor name in the vendor table. When I try to join the two tables,I am not getting all the info from the bill table. I can't figure out what i'm doing wrong.
Thanks,
P.
 
Try right-clicking on the join line to edit the join, and choose the appropriate option (All records from...).
 
Also, is there any doubt that the spelling in the bill table is consistent with the vendor table? Codes are usually more reliable that the names, since spaces or spelling become an issue. Just a thought.
 

Users who are viewing this thread

Back
Top Bottom