SELECT aaa.Name, aaa.CompanyName, aaa.State, aaa.Deep
FROM (SELECT b.Name AS Name, c.Company_Name AS CompanyName, c.State AS State,
a.Deep AS Deep
FROM Contract a LEFT OUTER JOIN
Floor_Office b ON a.Floor_Office_ID = b.ID LEFT OUTER JOIN
Company c ON a.Lessee = c.Company_Name
WHERE (b.Build_ID = '1') AND (b.Property_ID = '1') AND (a.DeleteFlg = 1) AND
(b.DeleteFlg = 1) AND (c.DeleteFlg = 1) AND (c.If_Cn = 1)) aaa,
(SELECT Name, MAX(Deep) AS Deep
FROM (SELECT b.Name AS Name, c.Company_Name AS CompanyName,
c.State AS State, a.Deep AS Deep
FROM Contract a LEFT OUTER JOIN
Floor_Office b ON a.Floor_Office_ID = b.ID LEFT OUTER JOIN
Company c ON a.Lessee = c.Company_Name
WHERE (b.Build_ID = '1') AND (b.Property_ID = '1') AND (a.DeleteFlg = 1)
AND (b.DeleteFlg = 1) AND (c.DeleteFlg = 1) AND (c.If_Cn = 1))
bbb
GROUP BY bbb.name) ccc
WHERE aaa.Name = ccc.name AND aaa.Deep = ccc.Deep
ORDER BY aaa.CompanyName
皇帝胡搞是游龙戏凤，
巡抚胡搞是深入群众，
知府胡搞是娱乐活动，
知县胡搞是体育运动，
小吏胡搞是胡乱打洞，
草民胡搞是流氓活动
============================
有客自东来,告我沈阳事,
甲申今岁无他论,唯庆清军入汉关.
闻客闲言做冷笑,长夜孤坐难入眠,
酒尽十杯心愈寒,弹剑金樽前,
杜鹃涕泣星月残,国耻激心阑.
昔时中国内战急,满奴乘间夺汉室,
中外当一家,留发不留头,
南来屠城九十九,汉血染尽汉河山.
读史至此不忍言,历史一长叹,
二百年来为猪狗,汉家英雄起报仇,
百万人头落,争得自由身.
三代安乐忘羞耻,白日繁星乌云连,
洪贼施逆成英豪,扬州十日内战篇,
豚尾大戏日日歌,万家迷倒满装前.
千载精忠事,不值一文钱,
武穆文山皆迂朽,好个智者余桂圆.
黄花冈上看黄花,黄花零落意沉沉,
十万万人齐倒戈,今日中国无汉人.
| -ICP -IDC -ISP |