Is it possible to give a "select" by merging two tables in MySQL? for example: I have a table named favorites that saves id and strong id . the idea is to go through the favorites table merged with the posts table, (where title, content and post etc are saved), and select all those posts according to the user_id of the favorites table?