Like
10g, we do not have available option to create Complex Joins from Toolbar. Can
only create “Foreign Key” Joins. But we can create complex joins using Join
Manager.
Go to
Manage > Joins > Actions > New Complex join .
Browse the physical tables on which you want to perform joins then create complex joins.
