I have 5 related tables.
The main table is meeting.
The other tables are participant_meeting, vendor,user_id, address.
I need the meeting information and the particpant who attentds the meeting(participant_meeting), and their address(address) the vendor for the meeting (vendors) , user_id for the participant(user_id) all the information for that meeting whether it exists or not. I am using a left outer join of the meeting with left outer join to get all the information. So, it is 4 left outer joins. Is there another efficient way to do this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!