error 206

[marcelofabiani]

Pues si pertenecen mi tabla es

CREATE TABLE "MONTOS"
(
"idmont" INTEGER NOT NULL,
"idcupie" INTEGER NOT NULL,
"monto" FLOAT NOT NULL,
"maquina" INTEGER NOT NULL,
"idplanilla" INTEGER NOT NULL,
"fecha" DATE NOT NULL,
"idcreditos" INTEGER NOT NULL,
PRIMARY KEY ("idmont")
);

y el select que deseo realizar es

select * from montos where (maquina=100) and (idcreditos=0)