>As a general statement, use an ALIAS after the "from".
>I'm not 100% positive if you're using SQL Passthrough from VFP, but as a general statement, I can do this in SQL server
>
>USE ProductionDB
>GO
>
>SELECT ProdTable.Name as ProductionName, TestTable.Name as TestName
>FROM ProductionTable ProdTable
> JOIN TestDB.TestingTable TestTable
> WHERE ProdTable.SomeKey = TestTable.SomeKey
>
>Once you have the ALIAS, you shouldn't need to have to reference the 2nd database every time (again, to best of my awareness, but I haven't done anything from VFP->SQL in a long time, so you might want to test to be sure)
I changed my SQL Select and started using the ALIAS. And indeed, the SQL Select is readable and works very well. Thank you.
"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
