select
	apm.admin_ID,
	flag =
	case 
		when apm.priv_ID is null then 0
		else 1
	end,
	apm.module_ID,
	p.name,
	m.module
from
	ADMIN as a join APM_LINK as apm 
		on a.ID = apm.admin_ID and a.firstname = 'simon'
	right join PRIVS as p 
		on p.ID = apm.priv_ID
	left join MODULES as m 
		on apm.module_ID = m.ID