I'm having those selects and i want to included in one !
(select acct.cmpcode,count(LCODE) from ACCT group by acct.cmpcode) as logar, (select count(LCODE) from ACCT where ISTRN = 1 ) as log_kinoum, (select count(ARTID) from arts ) as arthra_eggrafes, (select count(DISTINCT custid) from arts ) as syn_pou_kinith, (select count(DISTINCT trns.LCODE) log_pou_kinithikan from trns ,arts where arts.artid=trns.artid and arts.cmpcode=trns.cmpcode ) as logar_pou_kinith
I want each row to start with the acct.cmpcode and then the counts for each one ! How can i DO THIS ??