SELECT LG_XXX_KSCARD.CODE, LG_XXX_KSCARD.NAME, DEBIT-CREDIT
FROM LOGO.dbo.LG_XXX_XX_CSHTOTS LG_XXX_XX_CSHTOTS, LOGO.dbo.LG_XXX_KSCARD LG_XXX_KSCARD
WHERE LG_XXX_XX_CSHTOTS.CARDREF = LG_XXX_KSCARD.LOGICALREF AND ((LG_XXX_XX_CSHTOTS.TOTTYPE=1) AND (LG_XXX_KSCARD.ACTIVE=0))
ORDER BY LG_XXX_KSCARD.CODE