|
|
Posted by IchBin on 09/19/06 23:47
MS wrote:
>>>> I would love to keep my sort in my SQL but I am grabbing data from 3
> tables
>>>> I am sorting the data in the query from each table eg.
>
> Not used this for years and then it was not in MySQL...
>
> But I think the Union Statement would do the job for you...
>
> http://dev.mysql.com/doc/refman/5.0/en/union.html
>
> Best Wishes
> MS
>
> ----------------------------------------------------------------------------
> ----
> Join MyClubWeb.co.uk - The Home of Club Websites and Medium to Small
> Businesses.
> ----------------------------------------------------------------------------
> ----
>
>
Yes, that is what I thought at first. This would be the best/easiest way.
After looking at the MySQL it seemed that I could only do a UNION of two
tables. It really does not make sense to me. I swear in my past years in
programming some where either in Oracle or Sybase..BlabBlabBlab I had
done a UNION on like six or seven tables. I thought that was apart of
the SQL ansii. Guess I am getting old.
I think you should look at TEMP tables in MySQL. If it is anything like
what is in HSQLDB then it will save you a lot of cleanup. Yes, I can not
believe they are just coming out with views. One I the many reasons I
stay away from it when I can.
--
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
Navigation:
[Reply to this message]
|