28 Nov 2022
27 Nov 2022
Can WHERE syntax ne used for LEFT or RIGHT Joins?
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.