Union is not supported.
You can re-write the query as follows:
SELECT * from Clients
WHERE clientID in (select ClientID from ClientMatches where ClientMatchId=23)
OR clientID in (select ClientMatchID from ClientMatches where ClientID=25)
And so you can easily implement it.