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 HEADLINES
date:
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
date: headline (car_brand)
Can I do this without 2 select
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