Select G.id As GroupId, G.name As GroupName, L.Id As ListId, L.name As ListName From Grup G
Inner Join List L on L.grup_id=G.id