|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/20/2009 2:09:13 PM
Posts: 22,
Visits: 21
|
|
How do i generate a error ,when a set of records ina query do not intersect a set of records in another query.
For eg,
if I have a query ,
select A,b from ABC
INTERSECT
select B,d from XYZ
I want to display all records in ABC which do not intersect the b,d in XYZ.
What logic do I use ?
Thank you,
az_maverick
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 6/27/2009 9:41:50 PM
Posts: 2,
Visits: 3
|
|
Hello,
I want to display all records in ABC which do not intersect the b,d in XYZ.
What logic do I use ?
very simple with one field, try this
select A,b from ABC where b not in ( select d from XYZ)
bye
"Better to honestly fail than to achieve success through fraud". Sofocles
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/5/2009 3:21:51 PM
Posts: 101,
Visits: 241
|
|
Just switch INTERSECT set operator to MINUS
select A,b from ABC
MINUS
select B,d from XYZ
;
.If ActivityCount > 0 Then .Quit 99
|
|
|
|