又碰SQL难题 高手进, 关于多加一列

Question

   A表的结构如下:                  daochuID questionnaireID CityID ShopID zhuanGuiTypeID shopTime
                                   40000901 010318021116  3    18 2            u78
                                   40000801 010318021117  3    18 2            u78
                                   
  B表的结构如下                    questionnaireID ffff ccc
                                    010318021116       434       43
                                    010318021117       432       424
                                    010318021117       4656      64     
 B表的questionnaireID是A表的questionnaireID外键   现在需要B表多出一列来显示的要在A表的daochuID加上89（根据外键增加的）        则表显示的数据成这样  多出的列(dd)     questionnaireID    ffff     ccc
                                40000990        010318021116       434       43
                                40000891        010318021117       432       424
                                40000891        010318021117       4656      64
           

Answer 1

alter table b add dd int;
goupdate b
set dd=a.daochuID+89
from a
where a.questionnaireID=b.questionnaireID
go

Answer 2

select a.daochuID+89 as dd,* from a join b on a.questionnaireID=b.questionnaireID

Answer 3

select a.daochuID+89 as dd,b.* from a join b on a.questionnaireID=b.questionnaireID

Answer 4

select a.daochuID+89 as dd,b.* from a join b on a.questionnaireID=b.questionnaireID