Can you post the ddl and some sample data that would provide us the background for what you're looking to generate:
qry_id_2combo hic_number
qry_1&2 123456789A
qry_1&2 987654321A
qry_1&3 456789123B
We're guessing as to what the source data looks like exactly and that's not helping. See the first link in my sig if you'd like some assistance with that.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA