ultiple databases in one query. as?

45 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