sql - 获取最小值并集的最大值的sql字符串

Question

我有两个表，我想要一个 sql 查询来获取表最大值的并集字段的最小值。

Set tmpRS = CurrentDb.OpenRecordset(" SELECT MIN(s.TorqueMax) FROM ( " & _
    " (SELECT MAX(ds.TorqueMax) FROM tblUIOpTorqueRangeDS ds)" & _
    " UNION " & _
    " (SELECT MAX(cv.TorqueMax) FROM tblUIOpTorqueRangeCV cv )) as s")

标签： sqlms-access

Answer 1

你可以这样做：

SELECT MIN(s.TorqueMax)
FROM (SELECT MAX(ds.TorqueMax) as TorqueMax
      FROM tblUIOpTorqueRangeDS ds
      UNION 
      SELECT MAX(cv.TorqueMax) as TorqueMax
      FROM tblUIOpTorqueRangeCV cv
     ) as s;