|
|
Posted by IchBin on 09/21/06 22:37
moosus wrote:
> MS
>
> My problem is that I am on Ver3.23.37 of MySQL which like VIEWS doesn't
> support UNION's
>
> As well there is no primary key across these three tables.
>
> Where I am at at the moment I am querying all three tables for their latest
> 10 entries and writing these to a table I have labeled as temporary.
>
> This then allows me to run another select which will grab the latest 10 out
> of the 30 originally selected
>
> Cheers
> moosus
>
>
> in article TKmdnejctO7IGY3YUSdV9g@ptd.net, IchBin at weconsul@ptd.net wrote
> on 20/9/06 9:59 AM:
>
>> 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 MS, you nailed it. This is what I thought at first and it would be
>> the best/easiest way.
>>
>> After looking at the UNION statement out on the internet, have not used
>> for a while, it seemed that I could only do a UNION of two tables. It
>> really did 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 figured I am getting old.
>>
>> I just looked at the right place and you are, 100% right.
>
Sorry to hear about the sorry state of MySQL. They pretend to be
industry leaders when UNION and VIEW statements have been apart of the
SQL ANSII for so many years. I have for gotten how long. This is why I
do not use MySQL, if I am not forced to use it. Example: ISP Hosts. Hay
it's free. I would switch to Oracle, if possible.
--
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]
|