SELECT Statements with multiple sets of criteria

Question

SELECT Statements with multiple sets of criteria

Mark Harley

SSCrazy

Points: 2259
More actions
June 6, 2006 at 6:05 am

#172745

I need to to come up with a select statement that uses multiple sets of criteria. For example, I will use an initial select to grab @var2 from table A using @var1. I will then use a select on table B grabbing all rows that have EITHER @var1 OR @var2 in them. The complication arises when multiple rows are returned for @var2. How can I take this into account? An occasion could arise where @var1 is associated with two different instances of @var2. Does that make any sense?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

theogre SSC Enthusiast Points: 146 More actions · Answer 1

Is @VAR2 a field in TableA? Are you trying to return one record set? If TableA and TableB are alike you could union the results together.

Mark Harley SSCrazy Points: 2259 More actions · Answer 2

@var2 is a cell in table A, but there could be several rows returned. I think I got this working by nesting my selects and using IN as opposed to =. It appears to work, so far at least. Thanks for the help.

SELECT Statements with multiple sets of criteria

Cookies on SQLServerCentral