Resolved: The old syntax for joining using WHERE is only similar to inner join?

in SQL / The new and the old join syntax

Can WHERE syntax ne used for LEFT or RIGHT Joins?

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

28 Nov 2022

Hi Abdul!
Thanks for reaching out.

It can be used but it is not a good practice, so please stick to the new syntax. The operators which are used are *= and =* (depending on which side of the predicate each column is).

Hope this helps.
Best,
Tsvetelin

Helpful answer

Resolved: The old syntax for joining using WHERE is only similar to inner join?

Submit an answer

related questions