How to eliminate duplicate records without using distinct keyword

join shbcf.ru