sql query with a where clause
Posted on 2015-01-28
I have a query that works. Now I also have filter that called hub. The hub is location which if comprised of other locations.
For example, I want to say show me all the session within hub A (have location 1,location 2, location3).
The session have a table column locationKeyList which the is the list (1,2,3)
how can I construct my query where I can say
session.locationkeyList = values of the hub A (1,2,3)
Because I may pass a multiple hubs values to the query . Set of locations identify the hub