sql - 在 2 表中请求 SQL

Question

我希望合并 2 个 SQL 查询以进行优化，这是我的 2 个查询。

SELECT name, mess, image, date
FROM post_normal
WHERE name = flarize
ORDER BY date DESC

SELECT name, mess, image, name_second, image_second, quote, date
FROM post_special
WHERE name = flarize
ORDER BY date DESC

谢谢，我真的不知道该怎么做。

Answer 1

如果你需要两个结果是同一个表，你可以使用 UNION

    SELECT name, mess, image, null, null, null, date 
    FROM post_normal 
    WHERE name = flarize 

    UNION 

    SELECT name, mess, image, name_second, image_second, quote, date 
    FROM post_special 
    WHERE name = flarize 
    ODER BY date DESC

如果你需要在一行上你可以使用 JOIN

   SELECT a.name, a.mess, a.image, a.date
        , b.name, b.mess, b.image, b.name_second, b.image_second, b.quote, b.date 
    FROM post_normal a 
    LEFT  JOIN post_special b on a.name = b.name a.name = 'flariz'