Joining Two Databases 关注
I'm quite new to Bartender despite having the program for quite some time. I am currently trying to create a label with information from two databases(MySQL and PervasiveSQL), using two ODBC Data Sources to create my connection to the two Databases.
I am able to create a label with information from multiple tabels within PervasiveSQL using Left Outer Joins. I've used a custom query similar to this (table1 LEFT OUTER JOIN table2 ON tabel1.field1 = tabel2.field1) where 'field1' is the same data on both tables. Both tables are PervasiveSQL tables.
On another label I am able to retrieve data from a MySQL table. I would like to be able to retrieve data from both databases and print this information on a single barcode label.
Is it possible to create a query that grabs informaiton from two different databases.
SELECT database1.table1.field1 FROM (database1.table1 LEFT OUTER JOIN database2.table2 ON database1.table1.field2 = database2.table2.field2) where table1.field2='value'
Needless to say this returned a Database Error.
Any help would be much appreciated.