Show name when record from one table...

[ZPBJ]

doesn't exist in the other.

For example

Each project has a list of preferred vendors (one table)

When offers come in they are tracked (another table)

How can I report who hasn't bid?

Thanks

__________________________________
Remember that time when I took the box? - Peter

 

[PHV]

SELECT yourFieldList
FROM [one table] LEFT JOIN [another table]
ON [one table].VendorID = [another table].VendorID
WHERE [another table].VendorID Is Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ZPBJ]

I copied and inserted this, the next problem is that project does not create place holders for bids by default. So if it isnull, it's not normally in the table (the 2nd table from above)

__________________________________
Remember that time when I took the box? - Peter

 

[PHV]

Have you tried this query with the real table and field names ?
The important point is LEFT JOIN

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ZPBJ]

SELECT Vendor
FROM validVendors LEFT JOIN tblBidTracker ON [validVendors].VendorNumber = [tblBidTracker].Vendor
WHERE [tblBidTracker].Vendor Is Null;


__________________________________
Remember that time when I took the box? - Peter

 

[PHV]

And the question is ?

 

[traingamer]

SELECT Vendor
FROM validVendors LEFT JOIN tblBidTracker ON [validVendors].VendorNumber = [tblBidTracker].Vendor
WHERE [tblBidTracker].Vendor Is Null;

If that's your actual SQL, it'll always return a null set. You're asking to see the Vendor only if the Vendor is null.

Try SELECT VendorNumber ...

or some other field that'll actually show up from the validVendors table.

traingamer