SELECT O.OrderId, V.VendorName, O.Date, O.ReceiptNo, O.Comments, if(O.Received='B', 'Backordered', 'Ordered') as Status FROM T_VOrders as O, T_Vendors as V WHERE O.VendorId = V.VendorId AND O.Received <> 'Y' ORDER BY O.Date Vendor Order List - No Received Date Vendor Comments Receipt No Status