* 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 --------------------------------------------------------------------- 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