34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT DISTINCT
TOP 100 PERCENT dbo.Tmct_ac.mtaCompanyName, dbo.Tbzclass.bzName,
dbo.Tmct_info.mifYySj, dbo.Tmct_info.mifRdTj, dbo.Tmct_info.mifRjXf,
dbo.Tmct_info.mifDcDh, dbo.Tmct_info.mifZsImg, dbo.Tmct_info.mifDiZhi,
dbo.Tmct_ac.mtaId, dbo.Tmdclass.mdId, dbo.Tmct_ac.mtaType,
dbo.Tmct_info.mifDzXx, dbo.Tgds.gdId, dbo.Tgds.gdImg, dbo.Tmct_info.mifEMap,
dbo.Tmct_ac.pxdt
FROM dbo.Tmdclass INNER JOIN
dbo.Tmct_ac INNER JOIN
dbo.Tmct_info ON dbo.Tmct_ac.mtaId = dbo.Tmct_info.mtaId INNER JOIN
dbo.Tbzclass ON dbo.Tmct_info.bzId = dbo.Tbzclass.bzId ON
dbo.Tmdclass.mdId = dbo.Tbzclass.mdId LEFT OUTER JOIN
dbo.Tgds ON dbo.Tmct_info.mifId = dbo.Tgds.mifId
GROUP BY dbo.Tmct_ac.mtaCompanyName, dbo.Tbzclass.bzName,
dbo.Tmct_info.mifYySj, dbo.Tmct_info.mifRdTj, dbo.Tmct_info.mifRjXf,
dbo.Tmct_info.mifDcDh, dbo.Tmct_info.mifZsImg, dbo.Tmct_info.mifDiZhi,
dbo.Tmct_ac.mtaId, dbo.Tmdclass.mdId, dbo.Tmct_ac.mtaType,
dbo.Tmct_info.mifDzXx, dbo.Tgds.gdId, dbo.Tgds.gdImg, dbo.Tmct_info.mifEMap,
dbo.Tmct_ac.pxdt
ORDER BY dbo.Tmct_ac.mtaType DESC, dbo.Tmct_ac.pxdt DESC