t-sql table join

Question

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?

Answer 1

You can do this:

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

Answer 2

Select T.* from tbl1 T, tbl2 J

Answer 3

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