I'm not even sure what you're asking, so I can't find chapter and verse to help with your other questions.
Can you setup two actual tables with just enough data to describe this more effectively? The single table/two table/missing key/excluded value is just losing me without walking me through it in pinpoint precision.
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