Multiple joins in Oracle

From: Geo <gkont_at_emphasis-systems.gr>
Date: 28 May 2001 07:53:58 -0700
Message-ID: <fc9d4037.0105280653.9b0d4ac@posting.google.com>

I am trying to migrate from MSSql server to Oracle database and i have problem with this kind of sql statements (because Oracle does not allow multiple joins). Please help!

  SELECT lg.lg_account,
         lg.lg_title,  
         ca.ca_period_id,   
         ca.ca_title,  
         sum(dv.dv_debit) dv_debit,   
         sum(dv.dv_credit) dv_credit  

    FROM lg, ca, dv

   WHERE ( dv.dv_company =* lg.lg_company) and  


         ( dv.dv_ypok =* lg.lg_ypok) and  

         ( dv.dv_fyear =* lg.lg_fyear) and  

         ( dv.dv_chart_account =* lg.lg_chart_account) and  

         ( ca.ca_company *= dv.dv_company) and  

         ( ca.ca_ypok *= dv.dv_ypok) and  

         ( ca.ca_fyear *= dv.dv_fyear) and  

         ( ca.ca_period_id *= dv.dv_ins_period) and  

         ( dv.dv_account =* lg.lg_account) and  

         ( ca.ca_company = lg.lg_company ) and  

         ( ca.ca_ypok = lg.lg_ypok ) and  

         ( ca.ca_fyear = lg.lg_fyear ) and  

         ( dv.dv_is_budget = 'N') and 

         ( dv.dv_is_cashflow = 'N') and

         ( dv.dv_is_forcast = 'N' )   

 GROUP BY lg.lg_account,         lg.lg_title,     ca.ca_period_id,
          ca.ca_title
 ORDER BY lg.lg_account,            lg.lg_title,     ca.ca_period_id,
          ca.ca_title

Received on Mon May 28 2001 - 09:53:58 CDT