SELECT CAST(A.Closed AS INT) AS ClosedInt, A.*, B.Vendorname, SUM(C.Subtotal) AS InvoiceTotal FROM Invoice A JOIN Vendor B ON A.VenID=B.VenID JOIN LineItem C ON A.InvoiceID=C.InvoiceID WHERE A.InvoiceID=1000 GROUP BY A.InvoiceID, A.VenID, A.InvDate, 1Basically, convert the bit into an integer, then order by the integer.