gsSQL icon indicating copy to clipboard operation
gsSQL copied to clipboard

Implicit SELF JOIN syntax not supported.

Open demmings opened this issue 2 months ago • 0 comments

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.

demmings avatar Nov 04 '25 21:11 demmings