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@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 - 15:55:19 CDT