Additional Criteria in the JOIN Clause

Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause? Did you, like me, ask yourself, "Why did they put that in the JOIN instead of in the WHERE clause?" What difference does it make?

For the answer, see my article on SQLTeam.

posted @ Sunday, January 18, 2004 4:45 PM

Print
Comments have been closed on this topic.
«March»
SunMonTueWedThuFriSat
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234