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:
Hi,
Perhaps try to remove the brackets ?
SELECT location FROM visiExPr where location=1 UNION SELECT location FROM
visiExPr where location=0;
(I assume you're using MySQL 4.0.x ?)
Regards,
Jocelyn Fournier
- Original Message -
From: "Dan Liu" <[EMAIL PROTECTED]>
To: ">" <<[EMAIL PRO
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 the foll
