> -----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
> 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.
AFAIK, union is not implemented yet.
You might want to do it with 2 SELECT using a temporary table.