select 
distinct protokollnr
from antrag a
inner join AntragTPos atp on atp.protokollnr=a.protokollnr
left join tarifpos tp on tp.tpos=atp.tpos and tp.kassa=a.kasse and atp.ZeitraumID=tp.KZeitraumId
where
a.verrechnungsmonat>='2013-04-01' and a.verrechnungsmonat<'2013-07-01'
and tp.tpos is null

/* SQL-92 Table Creation Script with DBISAM Extensions */

CREATE TABLE IF NOT EXISTS "ANTRAG"
(
   "ProtokollNr" INTEGER NOT NULL,
   "Datum" DATE,
   "EinsenderID" INTEGER NOT NULL,
   "StationID" INTEGER,
   "EinsenderProt_Nr" VARCHAR(40),
   "PatientID" INTEGER NOT NULL,
   "Material" INTEGER,
   "Anamnese" MEMO,
   "Bemerkung" MEMO,
   "Abrechnung_Art" VARCHAR(1) DEFAULT 'V',
   "Abr_Privat_Adresse" VARCHAR(150),
   "Abr_Privat_PLZ" VARCHAR(10),
   "Abr_Privat_Ort" VARCHAR(40),
   "Kasse" VARCHAR(50),
   "Versicherung" VARCHAR(50),
   "EntnahmeDatum" DATE,
   "AnPatientschicken" BOOLEAN DEFAULT False,
   "Einsender2ID" INTEGER,
   "Station2ID" INTEGER,
   "Einsender2Prot_Nr" VARCHAR(40),
   "Einsender3ID" INTEGER,
   "Station3ID" INTEGER,
   "Einsender4ID" INTEGER,
   "Station4ID" INTEGER,
   "Material_Bemerkung" MEMO,
   "Klin_Diagnose" MEMO,
   "MV" INTEGER,
   "InfoText" VARCHAR(20),
   "VerrechnungsMonat" DATE,
   "AbrechnungAdresseExtra" MEMO,
   "NurVerrechnen" BOOLEAN DEFAULT False,
PRIMARY KEY ("ProtokollNr") COMPRESS FULL
LOCALE CODE 1031
);

CREATE NOCASE INDEX IF NOT EXISTS "DatumIndx" ON "ANTRAG" ("Datum") COMPRESS FULL;
CREATE NOCASE INDEX IF NOT EXISTS "FremdIndx" ON "ANTRAG" ("EinsenderProt_Nr") COMPRESS FULL;
CREATE INDEX IF NOT EXISTS "PatientID" ON "ANTRAG" ("PatientID") COMPRESS FULL;
CREATE INDEX IF NOT EXISTS "EinsenderID" ON "ANTRAG" ("EinsenderID") COMPRESS FULL;
CREATE INDEX IF NOT EXISTS "VerrechnungsMonatIndx" ON "ANTRAG" ("VerrechnungsMonat");

CREATE TABLE IF NOT EXISTS "AntragTPos"
(
   "AntragTPosId" AUTOINC,
   "ProtokollNr" INTEGER NOT NULL,
   "TPos" VARCHAR(8) NOT NULL,
   "Count" INTEGER DEFAULT 1,
   "ZeitraumID" INTEGER,
PRIMARY KEY ("ProtokollNr","AntragTPosId") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);


CREATE TABLE IF NOT EXISTS "TarifPos"
(
   "TarifPosID" AUTOINC,
   "Kassa" VARCHAR(10) NOT NULL,
   "TPos" VARCHAR(10) NOT NULL,
   "KZeitraumID" INTEGER NOT NULL DEFAULT 1,
   "Tarif" MONEY NOT NULL,
   "PosExtern" VARCHAR(20) NOT NULL,
PRIMARY KEY ("Kassa","TPos","KZeitraumID") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);