上代码:
View Code
1 SELECT a.ImageID,
2 a.BaseID,
3 a.BarcodeNum,
4 a.HandleMan,
5 a.ScanBaseID,
6 b.OperateType,
7 b.BillType,
8 b.pathid
9 FROM SSC.ImageGroup AS a
10 LEFT JOIN SSC.ImageFilePath AS b
11 ON a.imageid = b.imageid
12 WHERE b.pathid = (SELECT MAX(pathid) FROM SSC.ImageFilePath WHERE a.imageid = imageid ) --这个条件是关键