Hi there i am designing a system where users can upload revised versions of a file, so therefore newer versions of the file will need to be joined with the older original file. I'd need to join the parent file id with the child file id, would using a join table work ? I have tried something that is possible but i dont know if its the best way
files table: fileID filename userID join table joinID parent_fileID child_fileID select * from files f INNER JOIN jointable j on f.fileID=j.parent_fileID INNER JOIN files f2 ON j.child_fileID=f2.fileID is this correct ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
