同保障器下的区别数据库表之间的关联
原创今天遇到一个问题,就是我要把两个数据库里的两张表进行关联,下面是SQL语句:
SELECT A.*,B.第一列,B.第二列
FROM 数据库名.dbo.表名 as A
LEFT JOIN 数据库.dbo.表名 as B ON(A.ID = B.ID)

例如这个数据库student表:Art1.dbo.student (数据库名.dbo.表名)
版权声明
所有资源都来源于爬虫采集,如有侵权请联系我们,我们将立即删除
相关文章
最新文章
- 0.05ms 往返:localhost 为什么不能直接当网站? 5小时前
- Fornax's Guide to Fast Ethernet 5小时前
- Possibly leaked NSA Cyberattack tool behind attacks (2017) 6小时前
- Steve Wozniak on Writing Apple Integer Basic 6小时前
- PayByPhone is stealing $50M/year from their users 6小时前
- Grand Theft Auto 6: A Landmark Achievement That Redefines a Console Generation 6小时前
- Research Acceleration: The Jagged Frontier 7小时前
- Google Embraces Geothermal Technology to Vaporize Rock for Clean Power 8小时前
- Microsoft's Agent Framework PyPI package compromised to steal credentials 9小时前
- Nvidia's Seven Billionaires Have Lost a Third of Their Wealth 9小时前
itfan123

