Post reply

How to see if one column in a table matches a column in another table, when both tables are filtered with a WHERE clause

  • November 14, 2012 at 9:46 am

    #1559024

    Yes, imex, this also does what I need. Many, many thanks!

  • November 14, 2012 at 10:26 am

    #1559039

    As a final note, I've changed the two scripts from Mark and imex to read:

    SELECT COUNT(DISTINCT t2.DID) (Mark's script)

    AND

    select COUNT(DISTINCT d.DID) (imex's script)

    This gives me either no rows or a 1, indicating that either the LitHoldDetailsID (DID) doesn't or does meet the requirement, respectively. There's really no difference except that it is closer to a Boolean result which closer to how I'm conceptualizing this problem, as a yes-no question. It's all good. Thanks so much, everyone. 🙂

Viewing 2 posts - 16 through 17 (of 17 total)

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