Hello All,

I made a query for my reporting but stuck at a point. where i want all users with empty null data whom have no value.

for eg. my query like that

select c.name, a.id, b.user_name, e.emp_dptm, MAX(b.end_date) 
from  project_members_time b 
            join res_users a on a.id = b.user_name
    join res_partner c on c.id = a.partner_id 
    join project_project d on b.project_name = d.id 
    join hr_employee e on e.id = a.employee_id
    where d.state='open' and b.active_member = True 
    GROUP BY c.name,e.emp_dptm,b.user_name,a.id order by c.name asc;

And result is attachment 

and my total users are:

select id from res_users where active=True;

Now, i required all the 10 users and table structure according to first image. Mean in first image all remaining user should be show with null value.

Thanks in advance