Question

How to write SQL SELECT from 3 tables in SQL for MySQL in PHP

Answer 1

$sql = "SELECT posts.post_id, posts.post, users.user_id
        FROM posts
        INNER JOIN users ON users.user_id = posts.users_id
        INNER JOIN categories ON categories.category_id = posts.category_id
        WHERE users.user_id = " . $user_id;

70+ SQL courses for beginners and professionals