show us the syntax you tried ... there is no reason why you shouldn't be able to do that! kind regards, Lex. --------------------------------------------- Visit my website at http://www.naturaljoin.nl --------------------------------------------- I tried outer join here. It does not allow me to do outer join on more than 2 tables. I need outer join of account_tbl /destination and fiscal_year/destination. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l