Re: Simple SQL?
From: Vadim Tropashko <nospam_at_newsranger.com>
Date: Mon, 21 May 2001 20:55:19 GMT
Message-ID: <XgfO6.2365$r4.133875_at_www.newsranger.com>
Date: Mon, 21 May 2001 20:55:19 GMT
Message-ID: <XgfO6.2365$r4.133875_at_www.newsranger.com>
In article <53fO6.2335$r4.132474_at_www.newsranger.com>, Mikito Harakiri says...
>
>(SELECT a.a1,a.a2
>FROM a,b
>WHERE a.a1 = b.b1
>minus
>SELECT a.a1,a.a2 FROM a
>WHERE a.a1 IN (SELECT b.b1 FROM b))
>union
>(SELECT a.a1,a.a2 FROM a
>WHERE a.a1 IN (SELECT b.b1 FROM b)
>minus
>SELECT a.a1,a.a2
>FROM a,b
>WHERE a.a1 = b.b1)
>
Hmm... That's how I compared 2 queries as well. I guess I need to revise my practice... Wait a minute, does anybody has a solution how to compare bags in SQL? Received on Mon May 21 2001 - 22:55:19 CEST