Post reply

SELECT Statements with multiple sets of criteria

  • 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?

  • June 6, 2006 at 6:57 am

    #641950

    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.

  • June 6, 2006 at 6:59 am

    #641953

    @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.

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

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