Recent content by prab.raja

Thanks to all.... i got it.... the working query is below... SELECT x.code_number, x.vehicle_number, x.company_code, z.fc_valid_to, y.next_due_date FROM ([select code_number, vehicle_number, company_code from vehicledetails]. AS x LEFT JOIN [SELECT v.code_number, r.fc_valid_to FROM...

Thanks... But not Giving Expected result.... Thanks... But its not giving Expected result.... Original Oracle query: select v.code_number,v.vehicle_number,v.company_code,r.fc _valid_to, i.next_due_date from (vehicledetails v left outer join rtodetails r on v.code_number=r.code_number AND...

This is a Oracle query... its working in Oracle but didnt work in access... select v.code_number,v.vehicle_number,v.company_code,r.fc_valid_to, i.next_due_date from (vehicledetails v left outer join rtodetails r on v.code_number=r.code_number AND v.code_number='SMR5' left...