我想获得此记录的最大值.请帮帮我：
SELECT rest.field1
FROM mastertable AS m
INNER JOIN (
SELECT t1.field1 field1,t2.field2
FROM table1 AS T1
INNER JOIN table2 AS t2 ON t2.field = t1.field
WHERE t1.field3=MAX(t1.field3)
-- ^^^^^^^^^^^^^^ Help me here.
) AS rest ON rest.field1 = m.field
解决方法
您可以使用子查询…
WHERE t1.field3 = (SELECT MAX(st1.field3) FROM table1 AS st1)
但是我实际上将它从where子句移到join语句中,作为AND子句的AND.
