query errors

gudii9
gudii9 used Ask the Experts™
on
Msg 1013, Level 16, State 1, Line 1
The objects "XYZ" and "ABC" in the FROM clause have the same exposed names. Use correlation names to distinguish them.

wondering what it means by above error

please advise
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
That message tells you that you are using the exact same object twice or more in a WHERE/JOIN clause and you MUST use an alias name on each instance IF you really need to use that same object multiple times in the WHERE/JOIN's as shown here for example: https://www.sqlservercentral.com/Forums/1588361/FROM-clause-have-the-same-exposed-names-Reportbuilder
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Just for kicks and giggles please post the T-SQL that executed that generated this error.  Then click on the error message and watch the cursor jump to the offending line, and then tell us what line that is.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial