ultiple databases in one query. as?

42 views
Skip to first unread message

zubr...@gmail.com

unread,
Mar 14, 2018, 4:16:34 AM3/14/18
to sql2o
Databases Informix.

query:
SELECT t1.field, t2.field FROM db1:t1, db2:t2 WHERE t1.id=t2.id

how to execute this query using sql2o?

Select from several databases in one query. How to implement this?

zubr...@gmail.com

unread,
Mar 14, 2018, 4:58:53 AM3/14/18
to sql2o
Error preparing statement - A syntax error has occurred.

среда, 14 марта 2018 г., 11:16:34 UTC+3 пользователь zubr...@gmail.com написал:

zubr...@gmail.com

unread,
Mar 14, 2018, 6:25:45 AM3/14/18
to sql2o
As far as I understand, the point is in syntax informix. the table name and database name are separated ':'
But ':' it is also used in sql2o. how to get around this?

среда, 14 марта 2018 г., 11:58:53 UTC+3 пользователь zubr...@gmail.com написал:
Reply all
Reply to author
Forward
0 new messages