Reterieving records using sql

How to reterieve the record from the table by reducing duplicacy in case of joins using sql and then fetch the same record using php?