problem with left outer join
I have a sybase query that must be converted to an oracle query but Im getting the error
'a table may be outer joined to at most one other table'
the query used to work in Sybase (i didnt originally write it, I just have to convert it) heres the SQL
Select x, y, z (just for example purpose)
FROM tmp_epg_txs_ids etd,
txs_containers tc,
aspect_ratios ar,
formats f,
ancsvc st,
epg_templates et
WHERE etd.id = tc.id
AND tc.aspect_ratio_id (+)= ar.id
AND tc.format_id (+)= f.id
AND tc.ansv_method_st_code (+)= st.ancsvc_cod
AND tc.epg_template_id (+)= et.id
can anyone help ?
TIA