You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
26 lines
684 B
26 lines
684 B
#Parameter1:Jahr Zahlungseingang:INT:2015
|
|
#Parameter2:Mit Name:Table:Ja;Nein
|
|
/* SQL */
|
|
SELECT
|
|
faktura.Nrfaktura,
|
|
faktura.Datum,
|
|
privat.NRPRIVAT,
|
|
privat.NAME,
|
|
privat.VORNAME,
|
|
zahlung.Valuta,
|
|
zahlung.Betrag,
|
|
konto.Konto
|
|
FROM
|
|
faktura
|
|
INNER JOIN privat ON (faktura.Nrpatient = privat.NRPRIVAT)
|
|
INNER JOIN zahlung ON (faktura.Nrfaktura = zahlung.Nrfaktura)
|
|
INNER JOIN konto ON (zahlung.Nrkonto = konto.Nrkonto)
|
|
WHERE
|
|
year(faktura.datum) < #Parameter1 AND
|
|
year(zahlung.valuta) = #Parameter1 AND
|
|
year(faktura.datum) <> 2007 and
|
|
zahlung.status <> 9 AND
|
|
faktura.status <> 9 and konto.Konto='Bank Kasse Post'
|
|
ORDER BY
|
|
faktura.Datum,
|
|
faktura.Nrfaktura; |