mysql数据库查询添加另一个字段显示数据

原创于 2021-09-08 18:54:46 发布 · 7.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #big data #数据库

数据库笔记专栏收录该内容

14 篇文章

订阅专栏

该查询从新闻表中获取未删除和未保存状态的数据，重点关注与'learnOnline'项目相关的新闻。结果包括新闻的创建者、所属行业及项目名称，并按创建时间降序排列。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select n.*,i.industry_name as industry_name,a.name as create_user_name,
(select GROUP_CONCAT(p.name SEPARATOR ',') from project_relation pr left join project p on p.sign = pr.project_sign where pr.type = 'news' and pr.relation_id = n.id) as project_name
            from news n
            left join industry i on i.id=n.industry_id
            left join sys_admin a on a.id=n.create_user_id
WHERE n.state!='delete' and n.state!='save' and n.id in (select relation_id from project_relation where project_sign = 'learnOnline' and type = 'news')
order  by n.create_time desc