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
ing? UNION 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 MySQ
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:
>
To: ">" <<[EMAIL PROTECTED]>
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 FR
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
Than
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
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
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:
http://www
