Thanx, Roger.

Harald was right: What I want to do is a UNION which is not implemented
in mysql prior 4.0.0 :((

Your suggestion might work but I'm not sure if it's fast enough to be
done "on-the-fly" (i.e. during a http user request) due to the fact that
the tables are quite large and I have to "manually join" 10 tables :(


At 15:04 28.01.02 +0100, you wrote:
>* Tobias Kremer :: IT
> > Thanx dn. I know how to build joined selects but the problem is that those
> > two tables are not joinable. I don't have an entry in table 1 which
> > references to a field in table 2. I just want to create a list of
> > both tables ordered by date and limited to say 20 entries.
>
>I don't think it can be done with one statement in 3.23, but you can use
>multiple statements and a temporary table:
>
>create temporary table tmp1 select * from table1;
>insert into tmp1 select * from table2;
>insert into tmp1 select * from table3;
>select * from tmp1 order by date limit 20;
>
>--
>Roger

urbia Grüße - best regards

Tobias Kremer
Webmaster / Software-Entwicklung

urbia.com AG
Hohe Str.115,  50667 Köln

tel:    +49 (0)221 - 2949 154
fax:    +49 (0)221 - 2949 599
e-mail: [EMAIL PROTECTED]

http://www.urbia.de - we are family
http://www.urbia.fr - votre espace famille
http://www.urbia.co.uk - the family site

"Linux is like a wigwam. No gates, no windows
but an apache inside"


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to