yo tengo un problema  similar 
Mis tablas 
TABLE empleados(
	[id_emp] [int] IDENTITY(1,1) NOT NULL,
	[nom_emp] [nvarchar](50) NULL,
	[id_dist] [int] NULL, 
TABLE empleados_dist(
	[id_dist] [int] IDENTITY(1,1) NOT NULL,
	[nom_dist] [nvarchar](50) NULL,    
Código SQL:
Ver original- SELECT empleados.nom_emp, empleados_dist.nom_dist 
- FROM dbo.empleados,dbo.empleados_dist 
- WHERE empleados.id_dist=empleados_dist.id_dist 
- GROUP BY empleados.nom_emp