>But again...I *really* encourage you to use some type of proper alias. In all candor, it royally pisses me off when people don't do it.
Now that you mention it, what is the reason why an Alias should be used? For me this seems counter productive, unless you have a self join, but I see many people doing it. It was my impression to give a short name when the table names would be too long, but it does not necessarily make the select more readable.
Christian Isberner
Software Consultant