请用以下sql:
select collection_id,receipt_num from Qa_Results where collection_id in
( select collection_id from Qa_Results where RECEIPT_NUM = '304110034')
order by collection_id,receipt_num
select collection_id,receipt_num from Qa_Results where collection_id in
( select collection_id from Qa_Results where RECEIPT_NUM = '304110034')
order by collection_id,receipt_num
from Qa_Results A,
(select collection_id from Qa_Results where RECEIPT_NUM = '304110034') B
where A.collection_id = B.collection_id