如何在sql server中添加status列

问题描述

studentdetail table如下





studid移动课程描述

1000 9874511212 MFA master





smsdetail表格如下



关键字studid mobile replymsg

MFA 1000 9874511212已交付







i希望从smsdetail表获取replymsg。在上面的两个表课程和关键字匹配中，我想添加一个名为status的新列，在该状态下预订必须插入



查询如下



从studentdetail s选择c.replymsg，s.studid，c.mobile，smsdetail c其中s.studid = c.studid和s.mobile = c.mobile



输出如下



replymsg studid mobile

交付1000 9874511212


上面两张表中的
MFA就在那里。如果它匹配我想添加名为status的新列。

但是我希望输出如下



但我想要输出如下;



replymsg studid mobile状态

已发送1000 9874511212预订



为什么在sql server中怎么做。



问候，

Narasiman P.

解决方案

studentdetail table as follows


studid mobile course description
1000 9874511212 MFA master


smsdetail table as follows

Keyword studid mobile replymsg
MFA 1000 9874511212 delivered



i want to get the replymsg from smsdetail table. in the above two table course and keyword matches i want to add new column called status in that status booked has to be inserted

query as follows

select c.replymsg,s.studid,c.mobile from studentdetail s, smsdetail c where s.studid=c.studid and s.mobile=c.mobile

Output as follows

replymsg studid mobile
delivered 1000 9874511212

in the above two table MFA is there.if it matches i want to add new column called status booked.
but i want output as follows

But i want output as follows;

replymsg studid mobile Status
delivered 1000 9874511212 booked

for that how can do in sql server.

Regards,
Narasiman P.

解决方案

这篇关于如何在sql server中添加status列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！