SELECT LG_008_CLCARD.CITY, LG_008_CLCARD.SPECODE,LG_008_CLCARD.CODE , LG_008_CLCARD.DEFINITION_ , LG_008_06_PERDOC.LDATA, LG_008_06_PERDOC.INFOTYP,LG_008_CLCARD.CAPIBLOCK_MODIFIEDDATE AS [TARIH] , LG_008_CLCARD.CAPIBLOCK_MODIFIEDHOUR AS [SAAT], LG_008_CLCARD.CAPIBLOCK_MODIFIEDMIN AS [DK], LG_008_06_PERDOC.LREF FROM LG_008_CLCARD LEFT OUTER JOIN LG_008_FIRMDOC ON LG_008_CLCARD.LOGICALREF = LG_008_FIRMDOC.INFOREF LEFT OUTER JOIN LG_008_06_PERDOC ON LG_008_CLCARD.LOGICALREF = LG_008_06_PERDOC.INFOREF WHERE LG_008_CLCARD.CODE LIKE 'A%' AND LG_008_06_PERDOC.INFOTYP=21 order by LG_008_06_PERDOC.LREF