SELECT DISTINCT(Persons.ID), Grp FROM persons LEFT JOIN firstnames on (persons.Firstname = firstnames.Firstname) LEFT JOIN lastnames on (persons.Lastname = lastnames.Lastname) LEFT JOIN persextra on (persons.ID = persextra.ID) LEFT JOIN not_firstnamesextra on (persons.Firstname = Name) WHERE firstnames.Sortname = 'Anders' AND Name IS NULL ORDER BY lastnames.Sortname Unknown column 'Persons.ID' in 'field list'
Bergkvists släktforskning