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