求救:如何写这条SQL语句?

2005-09-15 10:49:06 169 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【Jlink & C#】通过C#实现Jlink RTT上位机的功能某天看到安富莱家的自己开发的调试器可以实现输出中文调试信息到自己编写的Jlink RTT上位机上，觉得无比神奇，略好奇到底是如何做的，找了很久，发现其上位机的对应的实现好像也没有完全开源出来。后来经过很多搜索确认，知道了几个事实:那么有没有可能用C#来控制Jlink呢？答案是，有！！！解决思路在于，C#调用JLinkARM.dll里面的函数这里转载下我认为很有意义的发现结合以上的几个发现，加上我自己的测试，我把我对接JLinkARM.dll的C#接口分享出来，不保证都能用，我只是测试了几个常用的功能，R 阅读详情

有test1和test2两个表,我想转变成test3,不知如何写SQL语句,请教各位大虾

表test1:
id modelcost modcompany
1 2 1
2 5 2

表test2:
id stonecost stocompany
1 2 1
3 4 2

表test3
id modelcost modcompany stonecost stocompany
1 2 1 2 1
2 5 2 0 0
3 0 0 4 2

...全文

TDISP（TEE Device Interface Security Protocol)软件操作流程 / 1. SPDM会话相关定义（🔶1-37、🔶1-187）// SPDM会话ID// AES-256-GCM加密密钥（TDISP要求）// 初始向量// 会话是否激活// 2. IDE流配置（🔶1-52、🔶1-625）// IDE流ID// 4个子流的AES密钥（覆盖所有子流类型）// 密钥是否已配置// 3. TDI状态与配置（🔶1-207、🔶1-210）TDI_CONFIG_UNLOCKED = 0, // 初始配置态。阅读详情

wclluck

智能路由器 684 成员 913 内容

+ 关注 + 加入社区

切换为时间正序

leeboyan 2005-09-15

打赏
举报

对，的确用full join，好久不来抢楼没感觉了

samfeng_2003 2005-09-15

打赏
举报

select isnull(a.[id],b.[id]) as [id],
isnull(a.modelcost,0) as modelcost,
isnull(a.modcompany,0) as modcompany,
isnull(b.stonecost,0) as stonecost,
isnull(b.stocompany,0) as stocompany
from @s1 a
full join @s2 b
on a.[id]=b.[id]
order by [id]

wgsasd311 2005-09-15

打赏
举报

来晚也：)

子陌红尘 2005-09-15

打赏
举报

select
id = (case when a.id is null then b.id else a.id end),
modelcost = isnull(a.modelcost ,0),
modcompany = isnull(a.modcompany,0),
stonecost = isnull(b.stonecost ,0),
stocompany = isnull(b.stocompany,0)
from
test1 a
full outer join
test2 b
on
a.id = b.id

软侠 2005-09-15

打赏
举报

看了樓上幾位代碼，我覺得都沒有精確理解樓主的意思，代碼都是錯誤的，應該如下寫才正確：
select ISNULL(t1.id,t2.id) id,isnull(t1.modelcost,0) modelcost,isnull(t1.modcompany,0) modcompany,isnull(t2.stonecost,0) stonecost,isnull(t2.stocompany,0) stocompany into test3 from test1 t1 FULL JOIN test2 t2 on t1.id=t2.id

必須要用到全連接才能達到樓主的要求，樓主可以把我上面的代碼拷進查詢分析器中直接運行，結果一定是樓主想要的正確結果

leeboyan 2005-09-15

打赏
举报

--上面test1和a中间没加空格
select isnull(a.id,b.id)as id,isnull(modelcost,0)as modelcost,isnull(modcompany,0)as modcompany,isnull(stonecost,0)as stonecost,isnull(stocompany,0)as stocompany into test3 from test1 a left join test2 b on a.id=b.id

leeboyan 2005-09-15

打赏
举报

select isnull(a.id,b.id)as id,isnull(modelcost,0)as modelcost,isnull(modcompany,0)as modcompany,isnull(stonecost,0)as stonecost,isnull(stocompany,0)as stocompany into test3 from test1a left join test2 b on a.id=b.id

lizhaogui 2005-09-15

打赏
举报

字段中加一个判断题条件NULL（字段名，‘0’）

lizhaogui 2005-09-15

打赏
举报

slect a.*,b.* from table1 a,table2 b
where a.id=b.id(+)
union
(slect a.*,b.* from table1 a,table2 b
where a.id(+)=b.id);

wclluck 2005-09-15

打赏
举报

谢谢各位，问题已解决，散分!!

jasengod2003 2005-09-15

打赏
举报

select ISNULL(t1.id,t2.id) as id,
isnull(t1.modelcost,0) as modelcost,
isnull(t1.modcompany,0) as modcompany,
isnull(t2.stonecost,0) as stonecost,
isnull(t2.stocompany,0) as stocompany into test3
from test1 t1 FULL JOIN test2 t2 on t1.id=t2.id
楼主试试吧，应该没问题啦！！！！！！

wclluck 2005-09-15

打赏
举报

在下先谢谢各位了，我先试一下马上结分

maxsolomon 2005-09-15

打赏
举报

select isnull(a.[id],b.[id]) as [id],
isnull(a.modelcost,0) as modelcost,
isnull(a.modcompany,0) as modcompany,
isnull(b.stonecost,0) as stonecost,
isnull(b.stocompany,0) as stocompany
from table1 a
full join table2 b
on a.[id]=b.[id]
order by [id]

lizhaogui 2005-09-15

打赏
举报

select isnull(a.[id],b.[id]) as [id],
isnull(a.modelcost,0) as modelcost,
isnull(a.modcompany,0) as modcompany,
isnull(b.stonecost,0) as stonecost,
isnull(b.stocompany,0) as stocompany
from table1 a
full join table2 b
on a.[id]=b.[id]
order by [id]

求救:如何写这条SQL语句?

相关推荐