Same exposed names

[rrajarat]

SELECT audit_trail.vendor,
SUM(audit_trail.quantity),
sdmn.reject,
vendor.code
FROM vendor LEFT OUTER JOIN sdmn ON
vendor.code = sdmn.supplier AND
sdmn.day >= '10/01/02' AND
sdmn.day <= '10/30/02',
vendor LEFT OUTER JOIN audit_trail ON
vendor.code = audit_trail.vendor AND
audit_trail.type = 'R' AND
audit_trail.date_stamp >= '10/01/02' AND audit_trail.date_stamp <= '10/30/02'
WHERE vendor.code = 'WHI018'
GROUP BY audit_trail.vendor,
sdmn.reject,
vendor.code

when I execute the above query I get this error:

Tables or functions 'vendor' and 'vendor' have the same exposed names. Use correlation names to distinguish them.

What does this mean? I thought it meant that sql server didn't know whether to use the vendor in the first or second join. If I am right how can I fix this problem?

Thanks for your help

 

[sunila7]

hi,

Try this query

SELECT audit_trail.vendor,
SUM(audit_trail.quantity),
sdmn.reject,
vendor.code
FROM vendor
LEFT OUTER JOIN sdmn ON vendor.code = sdmn.supplier AND sdmn.day >= '10/01/02' AND sdmn.day <= '10/30/02'
LEFT OUTER JOIN audit_trail ON vendor.code = audit_trail.vendor AND audit_trail.type = 'R'
AND audit_trail.date_stamp >= '10/01/02' AND audit_trail.date_stamp <= '10/30/02'
WHERE vendor.code = 'WHI018'
GROUP BY audit_trail.vendor, sdmn.reject, vendor.code

Sunil

 

[rrajarat]

Thanks sunila7 but this query gives 3 errors

Invalid object name 'vendor'.
Invalid object name 'sdmn'.
Invalid object name 'audit_trail'.

 

[sunila7]

Hi,

vendor,sdmn,audit_trail r these tables in ur DB, if not replace it with correct DB names

Sunil

 

[sunila7]

Hi,

vendor,sdmn,audit_trail r these tables in ur DB, if not replace it with correct table names

Sunil

 

[rrajarat]

Yes these tables are in the DB. I wish it was that simple

 

[SQLBill]

Are you running this in Query Analyzer? If not please do so. When you get the error message, double click on the error and see which line of code gets highlighted. Is it for sure the FROM section that is erroring?

-SQLBill

 

[rrajarat]

The second left outer join line gets highlighted