select * from myOrder ord inner join Customer cst on cst.CustomerId = ord.CustomerId where ord.DateFilled is null and ord.DatePlaced > getdate()