-Original Message-
From: Richard Whitney [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 10:54 AM
To: Jay Blanchard
Subject: RE: SELECT assistance
Quoting Jay Blanchard <[EMAIL PROTECTED]>:
> [snip]
> I have a table containing three columns:
>
> Int
[snip]
I have a table containing three columns:
Int intint
++-++
| id | serialbegin | serialend |
++-++
| 1 | 10 | 20 |
++-++
And say we have serial number 11.
Is there a way
I have a table containing three columns:
Int intint
++-++
| id | serialbegin | serialend |
++-++
| 1 | 10 | 20 |
++-++
And say we have serial number 11.
Is there a way to SELE
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"
> 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
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
: ()
Can I do this without 2 select queries?
As of now, I