I sort of know why this is happening. Just not sure how to correct it. My query:
SELECT Reg.firstname,Reg.lastname, Profiles.ProfileName FROM Profiles INNER JOIN Reg ON (Profiles.LID = Reg.RegID) INNER JOIN PSkicerts ON Profiles.ProfileID = PSkicerts.ProfileID) where Profiles.Status != 2 The table PSkicerts has multiple records for each ProfileID. When I run a results set I get back a row of the same firstname, lastname and profilename for each record that exists in PSkicerts under the same ProfileID. Now if I add a DISTINCT, that seems to fix it, but this is really part of a bigger query that has more tables similar to PSkicerts. When I add those into the mix, DISTINCT seems to no longer help. Hope this makes sense. Perhaps someone knows how I can fix it. Thank you, Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
