CODEWITHSUNDEEP
sqlt-sql
Gnomo
Gnomo

Reputation: 419

t-sql table join

Is there any way I can do a join between two tables where the resulting table has only the columns of the left table without the need to discriminate all the columns names in the select?

Upvotes: 0

Views: 148

Answers (3)

CaRDiaK
CaRDiaK

Reputation: 885

You mean something like 

Select t1.id, t1.name, t1.age FROM t1 INNER JOIN t2 ON t1.id = t2.id 
WHERE t2.Something = Something

Upvotes: 0

Dani
Dani

Reputation: 15079

Select T.* from tbl1 T, tbl2 J

Upvotes: 0

Raj More
Raj More

Reputation: 48034

You can do this:

Select LeftTable.*
From LeftTable
    Inner Join RightTable
        On LeftTable.Id = RightTable.Id

Upvotes: 3

Related Questions