需要更新table1基于table2任何人都可以帮助我... [英] Need to update table1 based on table2 can anyone help me with this...

问题描述

---- TABLE1 ----

----TABLE1----

medicareid   BMI
-----------  ----
1            null
2            null
3            null
4            null
5            null

---- TABLE2 ----

----TABLE2----

medicareid   BMI
-----------  ----
3            null
5            null

---- OUTPUT -----

----OUTPUT-----

medicareid    BMI
-----------   ----------------
1             null
2             null
3             no
4             null
5             null

我尝试了什么：



昨天的面试问题我试过加入但是没有得到它可以帮助我这个

What I have tried:

Yesterday interview question I tried join but not get it can anyone help me with this

推荐答案

这是今天你的第二个面试问题：至少这比你的第一个更复杂。

基于日期获取数据任何人都可以帮助我...他也给了我INPUT和OUTPUT [ ^ ]



你还没有为这份工作做好准备，而我们为你提供的解决方案对所有人都没有帮助 - 不是你，不会是谁一旦面试官询问细节，他的深度;可能根据我们的知识而不是你的知识雇用你的公司;或者可以通过这种明显的作弊来完成工作的申请人。



了解您的主题，申请您可以做的工作：或者您正在为自己做好准备秋天。

This is your second interview question today: at least this is slightly more complicated than your first one.
To fetch data based on dates can anyone help me with this...and he gave me the INPUT and OUTPUT too[^]

You are not ready for this job, and our giving you the solutions to them all helps no-one - not you, who will be out of his depth as soon as the interviewer asks about the detail; the company that might employ you on the basis of our knowledge rather than yours; or the applicants that can do the job which you might displace by this blatant cheating.

Learn your subject, apply for jobs you can do: or you are setting yourself up for a fall.

请阅读： UPDATE（Transact-SQL）| Microsoft Docs [ ^ ]，尤其是：根据其他表中的数据更新数据 [ ^ ]

Please, read this: UPDATE (Transact-SQL) | Microsoft Docs[^], especially this: Updating Data Based on Data From Other Tables[^]

这篇关于需要更新table1基于table2任何人都可以帮助我...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！