Select A.* Into #temp1 from(select A.field ,B.field ,C.field from tableA A inner join tableB B on A.field=B.field inner join TableC C on B.field=C.field where A.field= 11 ) as A Select B.* Into #temp2 from(select P.field ,Q.field ,R.field from tableP P inner join tableQ Q on P.field=Q.field inner join TableR R on Q.field=R.field where P.field= 11 ) as B SELECT a.* FROM #temp1 a Full outer JOIN #temp2 b ON (a.field1 = b.field1 and a.field2 = b.field2 ) WHERE b.field1 is null or b.field2 is null
select A.* from(select A.field ,B.field ,C.field from tableA A inner join tableB B on A.field=B.field inner join TableC C on B.field=C.field where A.field= 11) as A
select A.field ,B.field ,C.field from tableA A inner join tableB B on A.field=B.field inner join TableC C on B.field=C.field where A.field= 11
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)