InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 16:24:24 GMT20http://www.teradata.com/teradataforum/Topic14938-22-1.aspxJust switch INTERSECT set operator to MINUSselect A,b from ABC MINUSselect B,d from XYZ;.If ActivityCount > 0 Then .Quit 99Sun, 28 Jun 2009 06:12:40 GMTjimmhttp://www.teradata.com/teradataforum/Topic14938-22-1.aspxHello,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 thisselect A,b from ABC where b not in ( select d from XYZ)byeSat, 27 Jun 2009 22:12:36 GMTprodanluhttp://www.teradata.com/teradataforum/Topic14938-22-1.aspxHow 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 Mon, 30 Mar 2009 19:29:20 GMTaz_maverick