This query should fail with 5 "from clause not found where expected" errors, but..
it doesnt..
can someone else with oracle 9.2 offer any clues?
Code:
select
postcode
bank_acc_no,
bank_acc_no
postcode,
address_ref,
address_ref
postcode,
bank_sort_code
postcode
from
(select 'bsc' as bank_sort_code, 'bank acc no' as bank_acc_no from dual)
left outer join
(select 'bsc' as bank_sort_code, 'ar' as address_ref from dual)
using(bank_sort_code)
left outer join
(select 'ar' as address_ref, 'postcode' as postcode from dual)
using(address_ref)
results:
Code:
BANK_ACC_NO POSTCODE ADDRESS_REF POSTCODE POSTCODE
postcode bank acc no ar ar bsc