USE [eveonline]
GO

SELECT [typeID]
      ,[dbo].[invTypes].[groupID]
      ,[typeName]
  FROM [dbo].[invTypes]
  inner join [dbo].[invGroups] on [dbo].[invTypes].[groupID]=[dbo].[invGroups].[groupID]
  where categoryID = 6
GO