SQL Selecting Records -

i confused in selecting cars availability table want list available vehicles in given branch have written query brain stuck carry on !?

select model, make, start_date, termination_date  vehicle_type, vehicle, hire_agreement  vehicle_type.vehicle_type_ nun = vehicle. vehicle_type_no  , vehicle.vehicle_reg_num = hire_agreement.vehicle_reg_no , ; 

i believe start_date , termination_date can cars availability how??

first, should join instead of old school stuff. best can suggest given information have provided.

 select vehicle.model, vehicle.make, hire_agreement.start_date,     hire_agreement.termination_date  vehicle      natural inner join hire_agreement          hire_agreement.terminationdate >= date() , hire_agreement.start_date <= date(); 

this can considering didnt give schema or flavor of sql.