Re: Union does not work

2002-05-23 Thread Victoria Reznichenko
Dan, Wednesday, May 22, 2002, 7:16:50 PM, you wrote: DL Could somebody tell me what is wrong with this query? DL select location from visiExPr where location=1 union (select location from demandInfoAd where location=0); DL ERROR 1064: You have an error in your SQL syntax near 'union (select

Union does not work

2002-05-22 Thread Dan Liu
Hi, Could anybody tell me why the following query does not work? SELECT location FROM visiExPr where location=1 union (SELECT location FROM visiExPr where location=0); Thanks! Dan - Before posting, please check:

RE: Union does not work

2002-05-22 Thread Gurhan Ozen
Sub-selects are not permitted in MySQL yet.. See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Gurhan -Original Message- From: Dan Liu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 11:58 AM To: Subject: Union does not work Hi, Could anybody tell me why

Re: Union does not work

2002-05-22 Thread Victoria Reznichenko
Dan, Wednesday, May 22, 2002, 6:57:49 PM, you wrote: DL Could anybody tell me why the following query does not work? DL SELECT location FROM visiExPr where location=1 union (SELECT location FROM visiExPr where location=0); DL Thanks! What exactly doesn't work? Have you got an error or wrong

Union does not work

2002-05-22 Thread Dan Liu
Hi, Could somebody tell me what is wrong with this query? select location from visiExPr where location=1 union (select location from demandInfoAd where location=0); ERROR 1064: You have an error in your SQL syntax near 'union (select location from demandInfoAd where location=0)' at line 1

Re: Union does not work

2002-05-22 Thread Jocelyn Fournier
] Sent: Wednesday, May 22, 2002 5:57 PM Subject: Union does not work Hi, Could anybody tell me why the following query does not work? SELECT location FROM visiExPr where location=1 union (SELECT location FROM visiExPr where location=0); Thanks! Dan

RE: Union does not work

2002-05-22 Thread Sam Masiello
12:31 PM To: Dan Liu; Subject: RE: Union does not work Sub-selects are not permitted in MySQL yet.. See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Gurhan -Original Message- From: Dan Liu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 11:58 AM To: Subject: Union

RE: Union does not work

2002-05-22 Thread Gurhan Ozen
is implemented in 4.0.0. IF you have 3.x.x it won't work... Gurhan -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 12:31 PM To: Dan Liu; Subject: RE: Union does not work Sub-selects are not permitted in MySQL yet.. See: http://www.mysql.com