SELECT *  FROM `car_contract` inner join car_pur on car_contract.SaleId=car_pur.SaleId WHERE `CntrNo` LIKE  'ԇ%' 

SELECT *  FROM (`car_contract` inner join car_pur on car_contract.SaleId=car_pur.SaleId) left join car_fina_pay on car_pur.CarId=car_fina_pay.CarId WHERE `CntrNo` LIKE  'ԇ%' 

SELECT *  FROM (`car_contract` inner join car_pur on car_contract.SaleId=car_pur.SaleId) left join car_fina_rec on car_pur.SaleId=car_fina_rec.SaleId WHERE `CntrNo` LIKE  'ԇ%'

SELECT CntrNo,FrNo7,EndDat  FROM (`car_contract` inner join car_pur on car_contract.SaleId=car_pur.SaleId) left join car_fina_pay on car_pur.CarId=car_fina_pay.CarId WHERE `CntrNo` LIKE  'ԇ%' 

SELECT CntrNo,FrNo7,EndDat  FROM (`car_contract` inner join car_pur on car_contract.SaleId=car_pur.SaleId) left join car_fina_rec on car_pur.SaleId=car_fina_rec.SaleId WHERE `CntrNo` LIKE  'ԇ%'