Self Join #65
Description
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.
Additionally, the syntax to specify the table alias does not require "AS" in mySQL - however it is required with gsSQL. That I can live with for now.
Also, the explict JOIN syntax also fails. e.g.
select A.name as custname1, B.name as custname2 from customers as A join customers as B on A.id <> B.id