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
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:
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:
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 =
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: