Re: Multiple joins in Oracle

Oracle does allow multiple joins; I do it every day. Try replacing the * with a (+).
Jim

"Geo" <gkont_at_emphasis-systems.gr> wrote in message news:fc9d4037.0105280653.9b0d4ac_at_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 - 11:03:57 CDT