Join and 'using'
the visual query does not support a join with the keyword USING
ex : select * from a INNER JOIN b USING (id)
(almost equivalent to "select * from a INNER JOIN b ON a.id = b.id " but the field id would not be repeated) . the visual query tool sys that there is a syntax issue
I use Postgresql database
Hello,
Thank you for your feedback.
This is known problem, but unfortunately it cannot be fixed fast. You can write the queries containing the USING clause by hand on the SQL Text tab, Hopefully this problem will be fixed next year.