Hi All,
I have a set of clients in a table and a set of userid/clientids in another table. I am looking to get the list of clients for a given user ID.
Plainly I can do this using both linq and queryspec. Is there a best way for this type of query? One reason that I am leaning towards queryspec as it seems to me that it would be easy to set up a reusable predicate filter for the in component.
Select clients from client where client in (select client from clientuserlink where user = x)
Regards
Jon