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