Often joins are the most required for odd jobs around the site for mining a specific data or field. The efficient way to do this would be to join multiple tables having a common field and arriving at the field. This is also the reason why joins are the most confusing to apply on more than 2 tables.