主从表查询问题
要查找主表对应从表中日期最大的记录
select Box.BoxId,BoxCode,BoxModel,BoxChargeName,BoxCharge,BoxOutDate,BoxInDate,BoxRemark from Box,BoxInfo where ( Box.BoxId=BoxInfo.BoxId) and (BoxOutDate =
(SELECT TOP 1 BoxOutDate
FROM Box,BoxInfo where Box.BoxId=BoxInfo.BoxId
ORDER BY BoxOutDate DESC))
这是我写的,不对,请指教