Re: Need help with my LEFT JOIN query...

2004-07-12 Thread SGreen
Fax to: 07/10/2004 08:18 Subject: Need help with my LEFT JOIN query...

Re: Need help with my LEFT JOIN query...

2004-07-11 Thread Martin Gainty
: "Jeff Gannaway" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 10, 2004 5:18 PM Subject: Need help with my LEFT JOIN query... > I'm trying to SELECT a field (ProductID) from 'Table a' WHERE two > corresponding fields are equal (a.PUBLISHER =

Need help with my LEFT JOIN query...

2004-07-10 Thread Jeff Gannaway
I'm trying to SELECT a field (ProductID) from 'Table a' WHERE two corresponding fields are equal (a.PUBLISHER = b.Vendor AND a.NUMBER = b.VIN) Table 'a' (approximately 100,000 records): ++ | ImportLiebermansStep3Add | ++ | Prod