LarsBytes
Last Activity: Jul 1 '09, 09:42 AM
Joined: Feb 11 '09
Location:
-
ping! Is this very obvious? -
Single table condition in join or where
Hi all,
It is possible that this question has already been answered before, but I've searched through the forums and couldn't really find a satisfactory answer to the following question:
What is the difference in terms of execution and performance of the following queries on SQL SERVER 2005.
1.
SELECT *
FROM A a
JOIN B b ON (a.id = b.id)
WHERE a.x > 10 AND b.y < 100...
No activity results to display
Leave a comment: