CREATE TABLE #Groups
(
	group_id bigint NOT NULL,
	name varchar(100) NOT NULL,
	grouptype_id bigint NOT NULL,
	PRIMARY KEY (group_id)
);

CREATE TABLE #GroupTypes
(
	grouptype_id bigint NOT NULL,
	name varchar(30) NOT NULL,
	PRIMARy KEY (grouptype_id)
);

go 
insert into #Groups values (1, 'Group 1', 1);
insert into #Groups values (2, 'Group 2', 2);
insert into #Groups values (3, 'Group 3', 1);
insert into #Groups values (4, 'Group 4', 2);

insert into #GroupTypes values (1, 'Type 1');
insert into #GroupTypes values (2, 'Type 2');

-- I don't know if this is a good idea yet, but i would like to fill a template where
-- the values were inserted like these:

-- Group Name Type 1 Type 2
--   Group1     X      -
--   Group2     -      X
--   Group3     X      -
--   Group4     -      X

drop table #Groups
drop table #GroupTypes

SELECT 'Group Name'=AA.NAME, 
       'Type 1'= (CASE WHEN (SELECT TOP 1 name FROM #GroupTypes BB WHERE BB.grouptype_id=AA.grouptype_id)='Type 1' THEN 'X' ELSE '-' END),
       'Type 2'= (CASE WHEN (SELECT TOP 1 name FROM #GroupTypes BB WHERE BB.grouptype_id=AA.grouptype_id)='Type 2' THEN 'X' ELSE '-' END)
FROM #Groups AA
ORDER BY AA.NAME