Reputation: 4799
I have a query where I process columns from two tables and at the end I want ALL colulmns from one temporary table and ONLY ONE column from the other table. Also I do not want the KEY column to appear twice after the join.
I cannot find a clean efficient way to do it. I found these solutions:
Is there a one liner SQL command that leaves out a single column? Is there an SQL command that removes duplicate KEY column after joining?
Thanks!!
Upvotes: 0
Views: 345
Reputation: 1271241
How about selecting all columns from one table and one from the other?
select t1.*, t2.col
from t1 join
t2
on . . .
Upvotes: 3