Wednesday, February 10, 2010

Logo Tiger'da firma dönem bilgilerini listelemek

SELECT FRM.NR AS FIRMA_NO,FRM.NAME AS FIRMA_ADI
DONEM.NR AS DONEM_NO FROM L_CAPIFIRM AS FRM
INNER JOIN L_CAPIPERIOD AS DONEM ON FRM.NR=DONEM.FIRMNR
order by FRM.NR,DONEM.NR

No comments: