On Mon, 28 Jan 2002 14:49:18 +0100 Harald Fuchs <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>, > "Tobias Kremer :: IT" <[EMAIL PROTECTED]> writes: > > > Hi, > > 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. > > What you seem to want is a UNION, available in MySQL 4.0.0 and later. or maybe a MERGE table, available in 3.23 --------------------------------------------------------------------- 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
