MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Noel Clarkson Date:October 9 2000 12:03am
Subject:RE: simulating a union
View as plain text  
You could put/add the results of each query into a temporary table and then get php to
look at the temporary table.

cheers,
noel 

On Friday, October 06, 2000 8:36 PM, Roel [SMTP:roel@stripped] wrote:
> Hi,
> 
> Is there any way i can sort of 'simulate' a union operator? I want to do a
> select on 14 tables, but this is too slow (i had the query running for 10
> minutes then I just killed it), so now i want to select on 7 tables, do it
> again on the other 7 tables and do a union of this. But, there is no real
> union in mysql. Are there any other solutions? I want to access the data
> from php, is there any way I can do it in php?
> Thanks a lot.
> 
> cheers,
> 
> roel
> 
> 
> -- 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail mysql-thread52619@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-noel.clarkson=vic.uca.org.au@stripped>
> 
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
>     http://lists.mysql.com/php/unsubscribe.php

Thread
simulating a unionRoel6 Oct
RE: simulating a unionNoel Clarkson9 Oct