• mister.magoo (2/16/2011)


    Do you mean that out of the 16 qry_id values in the table, you just want rows that match two of those qry_id values.

    e.g. For table DEV_QRY_QC_HCC_131 containing these rows, you only want to select out where qry_id is 1 or 3 for example?

    qry_id hic_number

    1 1234546

    1 435676756A

    2 764321343

    3 794674hkf

    4 213126786638712

    giving these results:

    qry_id hic_number

    1 1234546

    1 435676756A

    3 794674hkf

    No, I'm looking for two-way qry_id combinations, by hic_number....