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

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