SELECTq1.qry_id,

q2.qry_id,

h.hic_number

FROM(

SELECTDISTINCT

qry_id

FROMdbo.DEV_QRY_QC_HCC_131

) AS q1

INNER JOIN(

SELECTDISTINCT

qry_id

FROMdbo.DEV_QRY_QC_HCC_131

) AS q2 ON q2.qry_id > q1.qry_id

CROSS JOIN(

SELECTDISTINCT

hic_number

FROMdbo.DEV_QRY_QC_HCC_131

) AS h