时间戳

首页 > 解决方案 > 使用内部选择连接来自 3 个表的数据

mysql - 使用内部选择连接来自 3 个表的数据

问题描述

我有以下查询：

SELECT *, CONCAT('/uploads/profiles/', user_uuid, '.jpg') as profile_pic,
(select count(*) from `good_reads_comments` b where a.id=b.parent_id) as child_post_count 
FROM `good_reads_comments` a,
(select count(*) from `comment_likes` c where a.id=c.comment_id) as 
 post_like_count 
FROM `comment_likes` a 
WHERE good_read_uuid='123456789' 
AND parent_id=0 
ORDER BY d_date

我的问题在于语法。没有第二次选择

((select count(*) from comment_likes c where a.id=c.comment_id) as post_like_count FROM comment_likes a)查询工作正常。

请帮忙

标签： mysqlsql

解决方案

我想你需要下面

 SELECT *, CONCAT('/uploads/profiles/', user_uuid, '.jpg') as profile_pic,
 (select count(*) from `good_reads_comments` b where a.id=b.parent_id) as 
child_post_count,
(select count(*) from `comment_likes` c where a.id=c.comment_id) as  post_like_count    
    FROM `comment_likes` a           
    WHERE good_read_uuid='123456789' 
    AND parent_id=0 
    ORDER BY d_date

推荐阅读