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
