Hi everyone, So I have 4 tables with different structures. They all have: - timestamp - the text (the actual comment I want to display) - a user id (which I can use to display the user's avatar) - a father id (which I can use to make the url) The problem is that in each table the name of the fields are different. For example: timestamp: time, timestamp the text: comment, text user id: u_id, userid father id: id, video_id Furthermore, depending on the content, the URLs would be different. So if it's a comment from the videos, the table name will be "video" and the url will be /video/id Can anyone please help me make a query that would display all comments in a single window? Ordered by time. Advice is much appreciated as I've never done such complicated queries.