|
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)
|