Are these joins the same?

sqlor · February 17, 2021, 1:49pm

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!

robert_volk · February 17, 2021, 2:17pm

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

Fred_unique · February 17, 2021, 2:31pm

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).