yanivhanya

tried to use "distinct", but i can't get all the table information by using it.

DISTINCT is working on select column list.

You must have to select only those columns which are giving you distinct records.

You can also use the rank/row number function to get the unique values.

Post your other tables structure with data & expected output