SELECT * FROM Interests INNER JOIN Interests AS I2 ON I2.lineID = Interests.interestOne INNER JOIN Interests AS I3 ON I3.lineID = Interests.interestTwo INNER JOIN Interests AS I4 ON I4.lineID = Interests.interestThree
The key is to use the AS statement so you can treat the same table as separate tables.