I begin with the query below:
select
table1.
from library1.table1
and I when type table1. <--- and when I type the period, rather then getting the fields in table1, it provides the names of other libraries I've listed in my ODBC connection
Also, this happens if I try to use an alias for the table name, like this:
select
t.
from library1.table1 as t
we have tables in many libraries that we use, all housed on the same database. for example, we may have:
library1:
table1
table2
librarya:
tablea
tableb
and we frequently create queries hitting multiple libraries:
select
t1.*,
ta.*
from library1.table1 as t1 inner join librarya.tablea as ta on t1.index = ta.index
