All Forums Database
az_maverick 24 posts Joined 03/09
30 Mar 2009
Generate error for intersection of queries

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 XYZI 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

cravetolearn 1 post Joined 12/08
07 Apr 2009

Hi Method 2----------select A,b from ABC minusselect B,d from XYZwill give all the records from ABC that do not match with XYZ.Method 1----------select B,d from XYZminusselect A,b from ABC will give all the records from XYZ that do not match with ABC.--> in both minus and intersect all the redundancy will be eliminated.I dont know what you mean by " How do i create an error ? "Sorry, if my answer do not answer your question........---------------------------------------------------------------------------------------------------------------------------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 XYZI 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

-Thanks
Siva

You must sign in to leave a comment.