gsSQL
gsSQL copied to clipboard
Implicit SELF JOIN syntax not supported.
Implicit SELF JOIN is not supported.
select A.name as custname1, B.name as custname2 from customers as A, customers as B where A.id <> B.id
This statement does not work with gsSQL(). It does work in mySQL.
However, if you use the explicit JOIN ON syntax for the self join, it will work.