SELECT     tbWebOrderHeader.WebJobNo, tbCarInfo.CarEngineNo, tbCarInfo.ChasisNo, tbWebOrderDetail.ProductItemID, tbWebOrderDetail.DealerPrice
FROM         tbWebOrderDetail INNER JOIN
                      tbWebOrderHeader ON tbWebOrderDetail.WebOrderID = tbWebOrderHeader.WebOrderID INNER JOIN
                      tbCarOnSale INNER JOIN
                      tbCarInfo ON tbCarOnSale.CarInfoID = tbCarInfo.CarInfoID ON tbWebOrderHeader.CarDataID = tbCarOnSale.CarOnSaleID
WHERE     (tbCarInfo.CarEngineNo = '1ZRX644598') AND (tbWebOrderDetail.CancelStatus = '' or tbWebOrderDetail.CancelStatus is null ) AND (tbWebOrderDetail.isCompleted = 'Y') AND (tbWebOrderDetail.isApproved='Y') AND (tbWebOrderHeader.CloseDate is not null) AND (tbWebOrderHeader.CancelDate is not null)