| MSSql to Oracle [message #374042] |
Tue, 22 May 2001 09:35 |
Georgia Kontaxi
Messages: 2
Registered: May 2001
|
Junior Member |
|
|
How can i make this query to run 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
