Select multiple join conditions at once
Posted: Wed 23 Apr 2014 09:16
Hi,
I have some tables where the joins happen on many columns, for example:
SQLComplete suggests the 5 conditions of the join, but I currently need to add them one by one:
I was wondering, is there any way to select all suggested conditions rather than adding them one by one? Similar to the way I can select multiple columns when doing a select by checking check boxes, which would allow me to select the 5 conditions of my join and add them all at once?
This is what I mean by "select by checking check boxes", can this be somehow activated to select multiple suggested join conditions based on column names to add them together?
I have some tables where the joins happen on many columns, for example:
Code: Select all
select *
from GEOINTERVAL as gi
join GEODETAILS as gd
on gi.HOLEID = gd.HOLEID
and gi.PROJECTCODE = gd.PROJECTCODE
and gi.GEOLFROM = gd.GEOLFROM
and gi.GEOLTO = gd.GEOLTO
and gi.PRIORITY = gd.PRIORITY- select first suggestion (gi.HOLEID = gd.HOLEID) , TAB to insert it, type 'and' to get next suggestion
- select second suggestion (gi.PROJECTCODE = gd.PROJECTCODE), TAB to insert it, type 'and' to get next suggestion
- ...
I was wondering, is there any way to select all suggested conditions rather than adding them one by one? Similar to the way I can select multiple columns when doing a select by checking check boxes, which would allow me to select the 5 conditions of my join and add them all at once?
This is what I mean by "select by checking check boxes", can this be somehow activated to select multiple suggested join conditions based on column names to add them together?
