[EMAIL PROTECTED] a écrit :
hi guys
i need help :-)
what is the problem :
(SQLite version 3.3.4, win XP)
i have a table:
CREATE TABLE plan(personid INTEGER, curseid INTEGER, statid
INTEGER);
INSERT INTO plan VALUES(1,1,0);
INSERT INTO plan VALUES(2,1,0);
INSERT INTO plan VALUES(3,1,0);
INSERT INTO plan VALUES(4,1,NULL);
INSERT INTO plan VALUES(5,1,NULL);
INSERT INTO plan VALUES(6,1,NULL);
INSERT INTO plan VALUES(7,1,NULL);
INSERT INTO plan VALUES(8,1,NULL);
-- ...
and i need to select all rows with "statid" = 0
so the query is :
SELECT statid
FROM plan P1
WHERE P1.curseid = 0;
BUT what a surprise, i got an empty result (i expect to get
rows No 1 to 3) !
any suggestions?
Yes :
SELECT P1.statid
FROM plan P1
WHERE P1.statid = 0;
instead of your query...
but you'll get only what you asked for : only O ;)
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com
