Simple SQL help needed…

[bhanab]

Please can you help me with syntax?

I have two table t1 and t2,

T1
id Des
1 Door
2 Book

T2
Id Des
1 CD
1 phone
2 office


How do I get these results ?

Id Des
1 door
1 CD
1 phone
2 book
2 office

[kestrel]

I have moved this to the forum.

[Vidhura]

Please can you help me with syntax?

I have two table t1 and t2,

T1
id Des
1 Door
2 Book

T2
Id Des
1 CD
1 phone
2 office


How do I get these results ?

Id Des
1 door
1 CD
1 phone
2 book
2 office

Select * from T1
union
Select * from T2

[bhanab]

Thanks for your reply...

How about this error, ... how can I get this to work ?


Declare @id int
Set @id = '1'

Select * from T1
union
Select * from t2
Where T1.id = @id and T2.id = @id

Msg 4104, Level 16, State 1, Line 4
The multi-part identifier "T1.id" could not be bound.

[bhanab]

Found it

Declare @id int
Set @id = '1'

Select * from T1 where id = @id
union
Select * from t2 where id = @id