From: Nicolas Prade
Date: March 3 2000 9:40am
Subject: RE: one query for two identical tables
List-Archive: http://lists.mysql.com/mysql/29940
Message-Id: <000e01bf84f4$8176dac0$04e12cd4@validator.cge.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> -----Original Message-----
> From: Tao Liang [mailto:taoliang@stripped]
> Sent: vendredi 3 mars 2000 06:23
> To: mysql@stripped
> Subject: one query for two identical tables
> 
> 
> Hi,
> 
> I have two tables with identical columns A B C D, where D is a numerical 
> column.  Is there a way to issue one query that returns A B C 
> columns from 
> both tables with the condition that D is greater than n (in either 
> tables)?  And, to sort the combined results on A?  I looked at the 
> documentation for JOIN but couldn't find much.
> 


Hello,
AFAIK, union is not implemented yet.
You might want to do it with 2 SELECT using a temporary table.
Nicolas.