某个工具中的SQL语句，求二个内联表中，B表的最大值的选项

SELECT     dbo.SampleBarcode.SampleBarcode, dbo.SampleBarcode.SampleStageID, dbo.SampleBarcode.SampleDate, dbo.SampleBarcode.SampleBit, 
                      dbo.SampleBarcode.SampleBitDate, dbo.StorageTable.SampleFrom, dbo.StorageTable.FromDate, dbo.SampleTable.SampleFactory, 
                      dbo.SampleTable.SampleRange, dbo.SampleTable.SampleWorkNO, dbo.SampleTable.SampleWorker, dbo.SampleTable.SampleArtNO, 
                      dbo.SampleTable.SampleBrand, dbo.SampleTable.sampleDate AS sampleInputDate, dbo.UserTable.UserName, 
                      UserTable_1.UserName AS Expr1
FROM         dbo.SampleBarcode INNER JOIN
                      dbo.StorageTable ON dbo.SampleBarcode.SampleBarcode = dbo.StorageTable.SampleBarcode INNER JOIN
                      dbo.SampleTable ON dbo.SampleBarcode.SampleID = dbo.SampleTable.SampleID INNER JOIN
                      dbo.UserTable ON dbo.SampleTable.SampleWorker = dbo.UserTable.UserID INNER JOIN
                      dbo.UserTable AS UserTable_1 ON dbo.StorageTable.SampleFrom = UserTable_1.UserID
WHERE     (dbo.StorageTable.StorageID IN
                          (SELECT     MAX(StorageID) AS Expr1
                            FROM          dbo.StorageTable AS StorageTable_1

                            GROUP BY SampleBarcode))