Cari Hesaplara bağlı muhasebe kodlarını gösteren sql
SELECT CLCARD.CODE, CLCARD.DEFINITION_, EMUH.MUHCODE, EMUH.MUHDEFINITION_
FROM LG_006_CLCARD AS CLCARD LEFT OUTER JOIN
(SELECT CRDACREF.CARDREF, EMUHACC.CODE AS MUHCODE, EMUHACC.DEFINITION_ AS MUHDEFINITION_
FROM lg_006_CRDACREF AS CRDACREF FULL OUTER JOIN
lg_006_EMUHACC AS EMUHACC ON CRDACREF.ACCOUNTREF = EMUHACC.LOGICALREF
WHERE (CRDACREF.TRCODE = 5)) AS EMUH ON CLCARD.LOGICALREF = EMUH.CARDREF
order BY code