Has anyone come across the error ORA-01445: cannot select from a join view without a key preserved table.


I have a view on the couple joins tables and I can't compile.