by ROCLASI » Mon Oct 08, 2012 10:28 pm
Hi,
You can't query 2 different databases with one query without some help.
1) Servoy itself allows for relations over different databases but it does in fact 2 queries and then combine it for you before it shows it, so Servoy does the heavy lifting for you (but has it's limitations).
2) You do the same as Servoy does yourself in code. This way you can use SQL for more complicated SELECTs.
3) Another way is to use a database connection inside the database server. Which means that (some) tables of database A are accessible in database B. This requires some configuration in database B and not all DB vendors support it. The SQL standard for this is called SQL/MED but not all vendors support it completely or have their own variation of it.
But only with option 3 you can use SQL to query your data from 2 databases in one go.
Hope this helps.