How to perform union in self service

Posts   
 
    
Posts: 87
Joined: 17-May-2011
# Posted on: 03-Aug-2011 16:09:07   

Select * from Clients where clientID in (select ClientID from ClientMatches where ClientMatchId=23 union select ClientMatchID from ClientMatches where ClientID=25)

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 03-Aug-2011 16:25:52   

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.