How to show union value for two query by union or full outer join odoo 11
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