Oh man! Yeah, you're right. That's exactly what I want but apparently it wasn't implemented until v4??!?!?!
What did people do prior to version 4 when needing to query multiple tables? Just endure the overhead of multiple connections to the database? Thanks. Neal -----Original Message----- From: Herman Verkade [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 12:14 AM To: 'neal' Subject: RE: multi-table select (not a join) You want to do a UNION. See: http://www.mysql.com/doc/en/UNION.html Regards, Herman Verkade > -----Original Message----- > From: neal [mailto:[EMAIL PROTECTED]] > Sent: 23 September 2002 07:57 > To: mySQL > Subject: multi-table select (not a join) > > > How do you select from two tables, without joining those tables? > > I just want the results of one table slapped on the end of > the results from > another table because I don't want the overheard of running > two seperate > queries. For instance: > > Lets say that I have these two tables (and thur values): > Foo Bar > a1 b1 a3 b3 c3 > a2 a2 a4 b4 c4 > > I would like a table (resultset) returned something like > this. Of course it > would need an additional field to specify which table the > values came from: > > a1 b1 foo > a2 b2 foo > a3 b3 c3 bar > a4 b4 c4 bar > > Anyone know how to do a query like this? > > Thanks. > Neal > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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