Ah, yes. Changed the SQL query back to what I had tried before, i.e.:
SELECT DISTINCT revision.RevisionID, Project_Name FROM revision INNER JOIN revisionProfiles ON revision.RevisionID = revisionProfiles.RevisionID
And set the column to ProfileID.
Which from a couple of tests looks like its all working as I'd expect.
Thanks again for helping out with that.