• Hope this code will work and if it satisfied with the ff requirements.

    1. You want to select distinct resultset.

    2. must have primary keys and foreign keys to join the three tables

    WITH CTE_DISTINCT(CLIENT_NUMBER)

    AS

    (SELECT DISTINCT CLIENT_NUMBER FROM CLIENT_TABLE)

    SELECT * FROM CTE_DISTINCT A

    INNER JOIN PRICE_TABLE B

    ON A.CLIENT_NUMBER = B.CLIENT_NUMBER

    INNER JOIN AUTHORIZATION_TABLE C

    ON B.CLIENT_NUMBER = C.CLIENT_NUMBER

    --WHERE <YOUR CONDITION HERE>