I'm working on a very large database, I have this piece of SQL in my script, but I've been informed that there is a more efficient way of doing this by using LEFT JOIN and checking for Null, but I'm not sure how to do this, any suggestions would be greatly appreciated.
...AND NOT EXISTS
(...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.