[SQL] Query returning more than one row with the same name
- by Neutralise
I am having trouble with an SQL query returning more than one row with the same name, using this query:
SELECT * FROM People P JOIN SpecialityCombo C ON P.PERSONID = C.PERSONID JOIN Speciality S ON C.GROUPID = S.ID;
People contains information on each person, Specialty contains the names and ID of each specialty and SpecialityCombo contains…