sql语句跨数据库的表联接

直接使用 数据库名.表名来联接

以mysql为例 说明跨数据库的表联接

1、 数据库 db1 表 tb1(uid,username,groupname)
2、数据库 db2 表 tb2(uid,phone,addr)

现在要联接tb1和tb2两张表

select a.uid as uid ,a.username as uname ,a.groupname as group,b.phone as phone,b.addr as addr
from db1.tb1 as a db2.tb2 as b
where a.uid = b.uid;