I have problem in sql query

Select A.No [T1],B.No [T2] from T1 A Full Outer Join T2 B On (A.No = B.No)

Go

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

(

	Select * from Table_1

	Except

	Select * from Table_2

)

Union

(

	Select * from Table_2

	Except

	Select * from Table_1

)

Declare @temp1 table

(

	id int,

	name varchar(10)

)



Insert into @temp1 values(1,'A')

Insert into @temp1 values(2,'B')

Insert into @temp1 values(3,'C')



Declare @temp2 table

(

	id int,

	name varchar(10)

)



Insert into @temp2 values(1,'A')

Insert into @temp2 values(2,'B')

Insert into @temp2 values(4,'D')





(

	Select * from @temp1

	Except

	Select * from @temp2

)

Union(



	Select * from @temp2

	Except

	Select * from @temp1

)

Sourabh07