Tam da sizin istediğiniz gibi bir query yazdım , fakat giriş ve çıkışlar ayrı satırlarda aynı satırda göstermek için çok daha profosyonel olan SQL cilere danışmak gerekir...
SELECT LG_086_CLCARD.CODE AS Kodu, LG_086_CLCARD.DEFINITION_ AS Ünvanı, LG_086_01_CSCARD.DOC AS Türü, LG_086_01_CSCARD.CURRSTAT,
LG_086_01_CSCARD.OURBANKREF, LG_086_01_CSCARD.PORTFOYNO, LG_086_01_CSCARD.SERINO, LG_086_01_CSCARD.BANKNAME,
LG_086_01_CSCARD.SPECODE, LG_086_01_CSCARD.CYPHCODE, LG_086_01_CSCARD.CITY, LG_086_01_CSCARD.OWING,
LG_086_01_CSCARD.KEFIL, LG_086_01_CSCARD.MUHABIR, LG_086_01_CSCARD.BRANCH, LG_086_01_CSCARD.DUEDATE,
LG_086_01_CSCARD.SETDATE, LG_086_01_CSCARD.AMOUNT, LG_086_01_CSTRANS.TRCODE
FROM LG_086_CLCARD INNER JOIN
LG_086_01_CSTRANS ON LG_086_CLCARD.LOGICALREF = LG_086_01_CSTRANS.CARDREF INNER JOIN
LG_086_01_CSCARD ON LG_086_01_CSTRANS.CSREF = LG_086_01_CSCARD.LOGICALREF INNER JOIN
LG_086_01_CSROLL ON LG_086_CLCARD.LOGICALREF = LG_086_01_CSROLL.CARDREF AND
LG_086_01_CSTRANS.ROLLREF = LG_086_01_CSROLL.LOGICALREF
GROUP BY LG_086_CLCARD.CODE, LG_086_CLCARD.DEFINITION_, LG_086_01_CSCARD.DOC, LG_086_01_CSCARD.CURRSTAT,
LG_086_01_CSCARD.OURBANKREF, LG_086_01_CSCARD.PORTFOYNO, LG_086_01_CSCARD.SERINO, LG_086_01_CSCARD.BANKNAME,
LG_086_01_CSCARD.SPECODE, LG_086_01_CSCARD.CYPHCODE, LG_086_01_CSCARD.CITY, LG_086_01_CSCARD.OWING,
LG_086_01_CSCARD.KEFIL, LG_086_01_CSCARD.MUHABIR, LG_086_01_CSCARD.BRANCH, LG_086_01_CSCARD.DUEDATE,
LG_086_01_CSCARD.SETDATE, LG_086_01_CSCARD.AMOUNT, LG_086_01_CSTRANS.TRCODE
HAVING (LG_086_01_CSCARD.DUEDATE > CONVERT(DATETIME, '2009-02-13 00:00:00', 102))
