select
	flag =
	case 
		when apm.admin_ID is null then 0
		else 1
	end,
	--m.ID as "module id",
	m.module,
	--p.ID as "priv id",
	p.name as "priv"
from
	MODULES as m cross join PRIVS as p
	left join APM_LINK as apm
		on apm.module_ID = m.ID and apm.priv_ID = p.ID
			and apm.admin_ID = (select ID from ADMIN where firstname = 'simon')
order by
	m.module