The 'fieldName' table has an ID and DivName for the Division List
The 'members' table has a Division1 and Division2 using the fieldName ID as entries.
My SQL Statement I need to list two columns one for Division1 and Divison2 but when I run this SQL statement, I get two lines for one member.
SELECT DivName, DivName FROM members INNER JOIN fieldName ON members.division1=fieldName.id OR members.division2=fieldName.id WHERE members.division1=3 OR members.division2=6
how to I run this SQL and one entry for each member?