Thanks for your help everyone. Did some further work last night and came up with a solution for my needs.

SELECT a.ur_number, b.ur_number, c.name_last, c.name_first

FROM SYS_CLI_Client a

INNER JOIN SYS_CLI_Client b ON...

Thanks Doug, But it does not seem to be filtering out the id's that are single entries.

Awesome!!! Result i needed. Thanks heaps 🙂