假如在一个数据库中有三个表 BOOK1(NAMEN,XUEHAO),BOOK2(XUEHAO,NIANJI),
BOOK3(XUEHAO,CHENGJI)
我现在在数据库中建一个表BOOK它里面包含NAME,XUEHAO,NIANJI,CHENGJI
用什么SQL语句把BOOK1,BOOK2,BOOK3这2个表的数据转移到BOOK表中
BOOK3(XUEHAO,CHENGJI)
我现在在数据库中建一个表BOOK它里面包含NAME,XUEHAO,NIANJI,CHENGJI
用什么SQL语句把BOOK1,BOOK2,BOOK3这2个表的数据转移到BOOK表中
select A.NAME,A.XUEHAO,B.NIANJI,C.CHENGJI
from BOOK1 AS A
left outer join BOOK2 AS B
left outer join BOOK3 AS C如果数据不正确请检查三个表之间的关系。
insert into BOOK (Name,XUEHAO,NIANJI,CHENGJI+50)
select A.NAME,A.XUEHAO,B.NIANJI,C.CHENGJI
from BOOK1 AS A
left outer join BOOK2 AS B
left outer join BOOK3 AS C
是不是可以这样