Banka fişleri

[yildirim]

Merhaba Arkadaşlar;
Aşağıdaki sorguya bnfline ve bnfiche tablolarını nasıl bağlayabilirim amaç  gönderilen havaleleri de getirip düşebilmek.

select CLCARD.CODE, CLCARD.DEFINITION_, PAYPLANS.CODE AS Vade, CASE INVOICE.TRCODE WHEN 1 THEN (INVOICE.NETTOTAL)
WHEN 4 THEN (INVOICE.NETTOTAL)
WHEN 5 THEN (INVOICE.NETTOTAL)
WHEN 13 THEN (INVOICE.NETTOTAL)
WHEN 6 THEN (INVOICE.NETTOTAL)*-1 END AS Tutar, INVOICE.DATE_
from LG_995_CLCARD AS CLCARD
INNER JOIN LG_995_PAYPLANS AS PAYPLANS ON CLCARD.PAYMENTREF=PAYPLANS.LOGICALREF
INNER JOIN LG_995_01_INVOICE AS INVOICE ON CLCARD.LOGICALREF = INVOICE.CLIENTREF
WHERE (INVOICE.TRCODE IN (1, 4, 5, 6, 13))
ORDER BY CLCARD.CODE

[Yazar]

Yazılar