On Monday 01 April 2002 10:56 am, IvanLatysh wrote: > Hi. > I am running MySQL 3.23.44-Max > > I have 2 tables. > > Table "A" > +---+--------+ > ID Name > +---+--------+ > 1 string 1 > 2 string 2 > +---+--------+ > > Table "B" > > +---+--------+ > ID Name > +---+--------+ > 2 string 2 > 3 string 3 > +---+--------+ > > And I need result > +---+--------+ > ID Name > +---+--------+ > 1 string 1 > 2 string 2 > 3 string 3 > +---+--------+ > How I could get (my version of mySQL haven't UNION statement)
Either upgrade your version of MySQL or use a temporary table. Copy table A into the temp table (T), then copy table B into T. Then select from T. --------------------------------------------------------------------- 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