This will get a manager of a team which contains a team which contains
individual nr 5.
SELECT I.Name FROM
TEAMREPORT T3
TEAMREPORT T2
TEAMREPORT T,
INDIVIDUAL I,
WHERE T.individualId = 5
AND t.teamid = t2.indivdualID
AND t3.IndividualId = t2.teamID
AND T3.IndividualID = I.IndividualID
AND I.Mana
SELECT * from tipps
WHERE (name like '%&name%' OR '$name' = '')
AND (stadt = '$stadt' OR '$stadt' = '')
AND (kueche = '$kueche' OR '$kueche' = '')
ORDER by $order ASC LIMIT $start, $limit
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 18 september 2001 13:05
To: M
i can reproduce it on 3.23.32
create table test (id int(13),low float(10,2) )
insert into test values (1,1)
insert into test values (1,'nan')
id low
1 1.00
1 nan
doh..
-
Before posting, please check:
http://w
you can rewrite this query to simple joins so you dont use sub selects.
select media.media_id , media.price, media.filename
from media,category_locks,categories
where media.media_id = category_locks.media_id
and category_locks.category_id = categories.category_id
and categories.dynamic_media = 't
if faq had a sequenced primary key you could do the following
select a.sezione, IF(a.sezione = b.sezione, "no","yes") as hasChanged
from faq as a, faq as b
where faq.id = faq.id -1
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 11:02 AM
To
if you use an alias in your select clause
use the same alias in the having clause
so having num > 1
-Original Message-
From: Ben Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 11:00 AM
To: [EMAIL PROTECTED]
Subject: COUNT and WHERE
Hello,
I have this query
select a.matc
