joining tables from other databases

carloss

unread,

Feb 8, 2012, 7:55:04 AM2/8/12

to NotORM

Hello!

I have question about joining tables:

How can I join tables across databases? Is that possible? Like
querying table database1.table1 and joining with database2.table2...

Our database contains thousands of tables spread over more
databases....

刘晨

unread,

Feb 8, 2012, 7:57:14 AM2/8/12

to not...@googlegroups.com

You should firstly make sure that you can do that with SQL.
As I know, MySQL has the function after version 5.

-----邮件原件-----
发件人: not...@googlegroups.com [mailto:not...@googlegroups.com] 代表
carloss
发送时间: 2012年2月8日 20:55
收件人: NotORM
主题: joining tables from other databases

carloss

unread,

Feb 8, 2012, 12:28:15 PM2/8/12

to NotORM

Well we do it with SQL every day, but we just want to use NotORM for
some project, that's why I am asking.

I am talking about queries like this:

SELECT j.*, c.client FROM recruits.jobs AS j
LEFT JOIN system.clients AS c
ON c.id=j.client_id

How I can do this in NotORM, considering jobs resides in database
recruites, clients resides in database system.

Any idea?

Reply all

Reply to author

Forward