This video explains how two sharepoint lists can be joined (left join same as sql) to get table with rows and columns based on dynamic filter query.
Please watch full video to understand the step by step procedure to create join and build dynamic query.