autoexcrement (7/10/2014)
I swear I remember reading somewhere about an alternate, shorter JOIN syntax in cases where the column being joined has the same name in both tables. But I can't seem to find a reference to it by Googling. Am I misremembering?It was something like this:
SELECT T1.ColIDFROM T1
INNER JOIN T2 ON ColID
I've never seen that in T-SQL. MySQL maybe?
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