Skip to Main Content

allow alias.* in conjunction with join ... alias using(..)

TPD-OpitzApr 3 2015 — edited Jan 11 2016

currently  (up to 12c) I get an error message when I write

select t2.* from table1 join table2 t2 using(the_common_Attribute)

When writing this I want all attributes from t2 which are not used in any USING() clause of the Statement.

I want to write "the_common_arttibute" explicitly in the Attribute list if it is needed there

bye

TPD

Comments
Post Details
Added on Apr 3 2015
2 comments
288 views