I would like to do something like:
- Code: Select all
SELECT onedb.*, otherdb.*
FROM server1.Database1.dbowner.myTable AS onedb
INNER JOIN server2.Database2.dbowner.myTable AS otherdb
ON onedb.id = otherdb.id
SELECT onedb.*, otherdb.*
FROM server1.Database1.dbowner.myTable AS onedb
INNER JOIN server2.Database2.dbowner.myTable AS otherdb
ON onedb.id = otherdb.id
rgansevles wrote:Robert,
Check on sql anywhere forums if this is possible.
Servoy will only join across databases when they are in the same jdbc connection.
If you want to use server2.Database2.dbowner.myTable in server1 you would need to expose it in server1, possibly as a view.
Rob
goldcougar wrote:For SQL Anywhere, I think your looking for is called proxy tables, where you create a table in your otherdb that is a proxy to onedb, and then you can join them with a sql query.
Users browsing this forum: No registered users and 23 guests