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