How to combine multiple SELECTs in one query?

Question

PHP

Here are two requests, I need to combine them into one request, tell me who knows

$request = "SELECT * FROM `news` ORDER BY `news_id` DESC LIMIT 6";

            $request = "SELECT cat.*, news.*
                                FROM news_category cat, news news
                                  WHERE news.news_category_value = cat.news_category_value
                                    AND news.news_id = news.news_id";

Answer 1

Do you need all the news and their categories?

SELECT news.*, cat.id, cat.title
FROM news
LEFT JOIN news_category cat ON news.category_id = cat.id
WHERE .....