1
SQL command to access other locations
Question asked by Hussain Shah Jaufar - May 3, 2016 at 10:27 AM
Answered
hi,
 
can i get SQL syntax to access other location added to Atrex ?

1 Reply

Reply to Thread
0
Terry Swiers Replied
May 3, 2016 at 10:41 AM
Employee Post
When you write your queries, you can include a database qualifier before the table names to allow you access to multiple databases.  So if you have two databases "Data1" and "Data2"  (BTW, these are the names defined in the database administrator), you can access either one by adding the qualifier before the table name
 
select * from "data1".code    --selects the inventory from the data1 database
 
select * from "data2".code    --selects the inventory from the data2 database
 
 

Reply to Thread