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?