From: Tao Liang
Date: March 3 2000 5:23am
Subject: one query for two identical tables
List-Archive: http://lists.mysql.com/mysql/29917
Message-Id: <4.2.0.58.20000302211613.00a0e7a0@cdr.stanford.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

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.

Tao