I think I mentioned to you that I do everything backwards :)
And if I piss off someone while doing it, it is an additional benefit :)
Thank you for your message. You answered the question.
>OK, maybe I wasn't completely clear in my example....the "TestTable" was in a different database (I referred to it as TestDB)
>
>But to answer your question.....
>
>This is (probably) not necessary
>SELECT TestTable.Name from MySecondSQLServerDatabase.TestTable where MySecondSQLServerDatabase.TestTable.first_name = 'XYZ'
>
>But this should work
>
>SELECT TestTable.Name from MySecondSQLServerDatabase.TestTable where TestTable.first_name = 'XYZ'
>
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham