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
> I want this output:
> NEWS HEADLINES
> : ()
> Can I do this without 2 select queries?
I
At 09:50 PM 1/29/2002 +0100, Torkil Johnsen wrote:
>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 HEADL