1金币
本帖最后由 mucai 于 2021-12-21 13:37 编辑
有一个简单的INNERJOIN联表查询,取表名和取字段,试了很多组合,都不行,不清楚这个命令的语法是怎么样的!如下的几个组合都试过,都不行
(1)
SELECT * FROM [rtyy_shop_mission] t1 INNER JOIN [rtyy_shop_mission_clerk] t2 ON t1.ID=t2.mission_ID
(2)
SELECT * FROM [rtyy_shop_mission] t1 INNER JOIN [rtyy_shop_mission_clerk] t2 ON t1.[ID]=t2.[mission_ID]
(3)
SELECT * FROM rtyy_shop_mission t1 INNER JOIN rtyy_shop_mission_clerk t2 ON t1.ID=t2.mission_ID
(4)
SELECT * FROM [rtyy_shop_mission] INNER JOIN [rtyy_shop_mission_clerk] ON [rtyy_shop_mission].[ID]=[rtyy_shop_mission].[mission_ID]
(5)
SELECT * FROM [rtyy_shop_mission] INNER JOIN [rtyy_shop_mission_clerk] ON [rtyy_shop_mission].ID=[rtyy_shop_mission].mission_ID
|
|