Join and 'using'

Avatar
  • updated
  • Completed

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

Avatar
Anonymous

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.

Avatar
YBN7RGB

Hello,

Is there any evolution for this problem ?

Thanks

Avatar
Anonymous

Hello, 

This problem will be fixed in the new major version. We are working on it now. Hopefully, it will be released until the end of this year.