SQLTeam.com | Weblogs | Forums

Are these joins the same?

Hello

Is
LEFT JOIN TABLE ON (A=TABLE.C AND B=TABLE.C)
the same as
LEFT JOIN TABLE ON A=TABLE.C x
LEFT JOIN TABLE x.B=TABLE.C
?

Thanks!

No, they are not the same. Neither syntax is correct for a LEFT JOIN. Please review the documentation:

1 Like

Sqlor, you are really trying the patience of our forum members by asking questions that show you refuse to learn anything or try anything before asking a question. There are good resources online that will get you started, for instance the W3Schools SQL Tutorial (a very simple beginning) or the SQLServerCentral Stairways series (a very extensive set of tutorials that work upward into more advanced topics).

1 Like