I am making a small forum based system and was wondering where would be best to store the ID of the user to created the thread. At the moment, to reduce data redundancy, I am not storing the data in the thread table and only in the post table (the first post of the thread is obviously the person who made it).
However, I ran into a few problems with the SQL. Is it possible, by using joins, to get the first post ID of the thread?
Thanks
