C chenba Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-10 #1 一个表Room<br>fFormNo,fRoomNo<br>另一个表RoomCha<br>fFormNo,fRoomNoCha<br><br>如fFormNo相同，将fRoomNoCha的值替代fRoomNo
一个表Room<br>fFormNo,fRoomNo<br>另一个表RoomCha<br>fFormNo,fRoomNoCha<br><br>如fFormNo相同，将fRoomNoCha的值替代fRoomNo
H hhjjhhjj Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-10 #2 Update Room Set fRoomNo = <br>(Select fRoomNoCha From RoomCha Where RoomCha. fFormNo=Room.fFormNo ) <br>Where fFormNo in (Select fFormNo From RoomCha)
Update Room Set fRoomNo = <br>(Select fRoomNoCha From RoomCha Where RoomCha. fFormNo=Room.fFormNo ) <br>Where fFormNo in (Select fFormNo From RoomCha)
J jenhon Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-11 #3 如果是MSSQL，我觉得应该这样写：<br><br>update Room set fRoomNo=RoomCha.fRoomNoCha<br>from RoomCha where Room.fFormNo=RoomCha.fFormNo
如果是MSSQL，我觉得应该这样写：<br><br>update Room set fRoomNo=RoomCha.fRoomNoCha<br>from RoomCha where Room.fFormNo=RoomCha.fFormNo
M makewater Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-11 #4 Update Room Set fRoomNo = <br>(Select fRoomNoCha From RoomCha ,room Where RoomCha. fFormNo=Room.fFormNo ) <br>Where fFormNo in (Select fFormNo From RoomCha)
Update Room Set fRoomNo = <br>(Select fRoomNoCha From RoomCha ,room Where RoomCha. fFormNo=Room.fFormNo ) <br>Where fFormNo in (Select fFormNo From RoomCha)
M mybabyben Unregistered / Unconfirmed GUEST, unregistred user! 2008-01-11 #5 update a <br>set a.fRoomNo=b.fRoomNoCha<br>from Room a ,RoomCha b<br>where a.fFormNo=b.fFormNo
