关于mysql的联合查询，如何从两个不同的表中汇总数据

2025-03-23 08:26:11

推荐回答（2个）

回答1：

使用UNION
select DEPT_NAME, USER_NAME, PHONE, CONTENT, SEND_TIME from sms3
UNION ALL
select DEPT_NAME,SENDER_NAME,MOBIL_NO ,CONTENT,DIA_TIME from diary

在每个select 语句中可以使用where 条件指定数据
两个表的对应列类型最好一致

SELECT ...
UNION [ALL | DISTINCT] SELECT ...
[UNION [ALL | DISTINCT] SELECT ...]

UNION is used to combine the result from multiple SELECT statements into a single result set.

The column names from the first SELECT statement are used as the column names for the results returned. Selected columns listed in corresponding positions of each SELECT statement should have the same data type. (For example, the first column selected by the first statement should have the same type as the first column selected by the other statements.)

回答2：

select +“需要显示的字段”+from sms3 as a inner join diary as b on a. DEPT_NAME=b.DEPT_NAME where +"加上自己的查询条件"

最新问答

配一台i5的电脑要多少钱？

WIN7下，我想给文件夹加密，但是加密选项不可选，请问是怎么回事？

谁知道东风风行菱智M3现在最低价位是多少，拉货怎么样，是不是很费油