SQL(二) 将一张表数据插入另外一张表

[html] 
INSERT INTO BaomingRelation  
           ([BaomingID]  
           ,[RelationNumber]  
           ,[UserID]  
           ,[Area])  
     SELECT BaomingID,NEWID(),OperUserID,'bj' from Baoming  
    where Area='bj'