Yes it is so easy.. You just need to use table joins.. Check out: http://www.mysql.com/doc/J/O/JOIN.html
Gurhan -----Original Message----- From: Torkil Johnsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:50 PM To: [EMAIL PROTECTED] Subject: Need some easy "select" assistance Given this example: table CARS has got an entity "Labourghini" with car_id=5 table NEWS has got an entity "Lambourghini displays new super model" with date=2002-05-02, news_id=735 and car_id=5 Now: I want this output: NEWS HEADLINES <date>: <headline> (<car_brand>) Can I do this without 2 select queries? As of now, I would typically first select news, then get the car_id from news and the do a select in the cars table, based on what kind of car_id the news entity returned. This should be pretty straight forward... I hope :) - Torkil --------------------------------------------------------------------- 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
