如何能让这条SQL语句改成标准的SQL语句,即将(+)去掉
如何改写一条标准的SQL语句,将sms_business_area.id(+) ,sms_user.id(+) 这二个条件的(+)号去掉。
SELECT sms_business_area.description, sms_user.full_name, sms_sub.full_name,
sms_stb_type.vendor, sms_sales_header.business_date,
sms_sales_header.actual_amount
FROM sms_sub_stb_type,
sms_sub,
sms_sales_header,
sms_stb_type,
sms_user,
sms_business_area
WHERE ( (sms_sub.id = sms_sub_stb_type.sub_id)
AND (sms_sub.id = sms_sales_header.sub_id)
AND (sms_stb_type.id = sms_sub_stb_type.stb_type_id)
AND (sms_business_area.id(+) = sms_user.business_area_id)
AND (sms_user.id(+) = sms_sub.staff_id)
)