HomeFlySpeed SQL Query"USING" Join Condition not supported?

"USING" Join Condition not supported?


This query is illegal for SQL-Query?

SELECT * FROM person p JOIN person_attr pa USING(person_id)

Error message is:

Invalid SELECT statement.
Unexpected token "USING" at line 1, pos 44
Bruno Baketaric | email
January 12 2011, 09:13 AM
Dear Bruno,

Such syntax is not supported by visual query builder. What is your database server?

You may hide visual query builder and write such queries using the text editor. Choose "Query" - "SQL Text Mode" main menu item to switch off the visual query builder.
Sergey Smagin | email
1 hour, 51 mins since original post
Hi Sergey,

thanks for answering so fast...

Well, it's a MySQL 5.1 (Debian, dotdeb.org repository).

And what I exactly did was to take an existing query from my PHP Application and pasted it into the Text-Pane (with the "visual" pane activated). Usually, as soon as I click somewhere outside of the Text-Page, the Visual-Pane is updated and I see the tables, relations etc. - This works very well and I'm really getting used to it, but as soon as there's a USING clause, I get the described error.

Any chance, that Query-Builder will support that syntax in the near future?
Bruno Baketaric | email
2 hours, 27 mins since original post
Dear Bruno,

We will add support of this clause in one of the next minor versions. We do not have exact date when this will happen. May be it'll take 2-3 months.
Sergey Smagin | email
20 hours, 52 mins since original post
This topic is closed