才接触mysql。不知道能不能跨库查询,今天试了试,成功了。
Mysql版本号:mysql5.6
下面是代码:
- SELECT
- tab1.address as 'tab1.address',
- tab2.address as 'tab2.address'
- FROM
- test.address as tab1,
- sakila.address as tab2
- where tab2.address = '47 MySakila Drive'
- and tab2.address = tab1.address
自己建立测试数据库测试下吧。和mssql 一样。