Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
You need to get the basics cleared, Whatever LEFT JOIN you are doing isn’t impacting the final result set of this sql. If you say it’s mandatory then it must be changed to INNER JOIN.
I also realized that you only need a TABLE A in the entire sql , remove the EXISTS from my sql suggested and run.
If you can not get it understand and done then I am sure the topic will be locked soon as the post isn’t going nowhere because you keep asking the same question when provided answers and explanations repeatedly. |
|