DB2 Join shortcuts - isn't there a special way you can join if the column name is the SAME in the 2 tables being joined
Posted on 2014-09-24
I seem to recall reading there is a special way you can join if the column name is the SAME in the 2 tables being joined. The perk to using this method is that when joining on this same column, the result set only gets the column one time. So if you used this other syntax instead of "from t1 left join t2 on t2.mycol = t1.mycol" then "mycol" would only exist once in the joined result set.
Or maybe I just dreamed that?