how can i make this query to work in Oracle??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