Re: EXCEPT statement in MYSQL?

2001-05-15 Thread Bob Hall
>On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote: > > > > Hi, > > > > I am new to this list, so maybe this question is asked before. > > > > I like to know how to use the except statement in MYSQL. EXCEPT is > &

Re: EXCEPT statement in MYSQL?

2001-05-15 Thread Peter Pentchev
On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote: > > Hi, > > I am new to this list, so maybe this question is asked before. > > I like to know how to use the except statement in MYSQL. EXCEPT is > (almost?) the same as an exlusive or (XOR): > &g

EXCEPT statement in MYSQL?

2001-05-15 Thread Viktor van den Berg
Hi, I am new to this list, so maybe this question is asked before. I like to know how to use the except statement in MYSQL. EXCEPT is (almost?) the same as an exlusive or (XOR): select userid from user1 except select userid from user2 The result is a data set containing userid's tha