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
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:
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
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
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
]
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
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
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