Join of two table and get the distinct records with three fields.
I want to retrieved all the fields from two tables using join and apply distinct clause on three fields.
I have table User which has fields id,name,lastname,dob
and another table education_info id, id_user(which is reference of user table),school_name,addresss.
I have to retrieved the fields name,lastname,dob,school_name,address in which following fields are distinct name,lastname and shool_name.