How can I create a SQL Server equivalent of this query?

```
SELECT m.ItemId
    ,item.NAME
    ,m.Expiratory
    ,m.t AS TotalNumber
FROM item
    ,(
        SELECT ItemId
            ,Expiratory
            ,sum(TotalNumber) t
        FROM inbox
        GROUP BY Expiratory
            ,ItemId
        ) m
WHERE (
        (
            m.ItemId
            ,m.Expiratory
            ) NOT IN (
            SELECT ItemId
                ,Expiratory
            FROM outbox
            GROUP BY Expiratory
                ,ItemId
            )
        )
    AND (item.ItemID = m.ItemId)

```