List:General Discussion« Previous MessageNext Message »
From:Nicolas Prade Date:March 3 2000 9:40am
Subject:RE: one query for two identical tables
View as plain text  

> -----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.

Thread
AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsMicheal Mc Evoy11 Mar
  • one query for two identical tablesTao Liang3 Mar
    • RE: one query for two identical tablesNicolas Prade3 Mar
  • group by conditionsTao Liang5 Mar
    • Re: group by conditionssinisa6 Mar
      • accessing db while updating itTao Liang26 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsRobert Hazeltine11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • select count distinctChinaConnect11 Mar
    • Re: select count distinctChris12 Mar
    • Re: select count distinctScott Liu13 Mar
      • Re: select count distinctMichael Widenius15 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsChristian Mack12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp13 Mar
Re: Bad handshake problem with java and MySQL 3.22.32Carlos Proal15 Feb