如何用2个表分组 [英] how to group by with 2 tables

问题描述

SELECT
   T1.id,T1.RANK,T1.fullname,T2._time,T2._date,T1.casing,T1.munit
FROM
   (SELECT DISTINCT id,rank,fullname,casing,munit,ending,frsrank FROM tblmain) T1
   FULL OUTER JOIN
   (SELECT DISTINCT num,_time,_date  FROM tbl_secure_mornning) T2
              ON T1.id = T2.num where T1.ending ='false' and T1.frsrank between 15 and 16;

< br $> b $ b



如何使用T1.munit对此查询进行分组？

how to group by this query with T1.munit ?

推荐答案

难道你不能这样做..

Can't you just do it like this..

SELECT SELECT DISTINCT
	 T1.id
	,T1.RANK
	,T1.fullname
	,T2._time
	,T2._date
	,T1.casing
	,T1.munit
FROM tblmain T1
	LEFT OUTER JOIN tbl_secure_mornning T2 ON T1.id = T2.num 
WHERE T1.ending ='false' 
	and T1.frsrank between 15 and 16
GROUP BY T1.munit

您可以使用CTE（公用表表达式）...

You can use CTE(Common Table Expression) for that...

这篇关于如何用2个表分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！