SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
FR: popup for USING clause

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
FR: popup for USING clause
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post FR: popup for USING clause Reply with quote
Currently, there's no popup listing the column candidates triggered by the USING clause, meaning that one has to know the possible column names without any hints from SA at all. I know that natural joins (and USING) are frown upon most of the times but they tend to come in handy when hastily constructing queries for investigating data contents, so it would be nice if SA could provide some aid there too.
Mon Nov 04, 2019 8:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
Are you referring to a case like

Code:
SELECT film.title, film_id -- film_id is not prefixed
FROM film
JOIN film_actor USING (film_id)
WHERE ...

Wed Nov 06, 2019 10:03 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
Affirmative.
Wed Nov 06, 2019 10:35 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
I can whisper that 11.1 is now out, and this is one of the enhancements available in that new version. A formal announcement may come at the end of the week, yet 11.1 is already available for download.
Tue Nov 26, 2019 2:38 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
This seems to be working to an extent. It works automatically when I try to INNER JOIN two tables that are not actually connected by foreign keys. If it finds common columns it adds them using USING (instead of using ON with the columns and equality).

However, I might want to use USING even if there's a foreign key defined (to eliminate column duplicates, for example). I expected it to show a popup after the keyword USING with the matching columns (similar to that the ON keyword triggers) but nothing happened. Wasn't that the intended behavior here?
Sat Dec 14, 2019 10:16 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.