sql的问题！

[xu_chenhao]

我有表1 A
字段：ID（自增） loginId aaa bbb ccc ggg hhh
1 My 111 222 333 321 123
2 My 222 333 444 456 654
3 You 222 555 444 345 543
4 You 111 222 555 234 432
5 You 222 333 444 232 324
......


表2 B
字段：orderId（自增） aaa bbb ccc ddd eee

我要根据select * from A where loginId = My查出的数据插入到表B怎么做？
2个表有不同字段啊 我是新手
谢谢

[feixianxxx]

insert into b(aaa  bbb  ccc  ddd  eee) 
select aaa , bbb, ccc , ggg , hhh 
from A where loginId = 'My'

[昵称被占用了]

insert b(aaa,bbb,ccc,ddd,eee)
select aaa,bbb,ccc,ggg,hhh from a
where loginId = 'My'

[jwdream2008]

insert into B select aaa,bbb,ccc,ggg,hhh from A where loginID=@ID  

[昵称被占用了]

如果只转移相同字段

insert b(aaa,bbb,ccc)
select aaa,bbb,ccc from a
where loginId = 'My'

[水族杰纶]

insert tb(aaa,bbb,ccc,ddd,eee) select aaa,bbb,ccc,ddd,eee from a where where loginId = 'My'  

[guguda2008]

INSERT INTO B(AAA,BBB,CCC)
SELECT AAA,BBB,CCC,GGG,HHH FROM A WHERE LOGINID='MY'

[jwdream2008]

insert into B (aaa,bbb,ccc,ddd,eee) 
select aaa,bbb,ccc,ggg,hhh from A where loginID=@ID 

[xu_chenhao]

[SQL77]

INSERT B(aaa  ,bbb , ccc,  ddd , eee )
SELECT aaa  ,bbb,  ccc,  ddd  ,eee  FROM A WHERE loginId = 'My'

[jwdream2008]

insert into B (要插入的字段) 
select 需要查询的字段 from A where loginID=@ID 

[feixianxxx]

[Quote=引用 9 楼 xu_chenhao 的回复:]

[/Quote]

你想转移A的那些字段？

[--小F--]

insert into 
  B(orderId,aaa,bbb,ccc,ddd,eee) 
select 
  id,aaa,bbb,ccc,ggg,hhh  
from 
  A 
where 
  loginId = My

[guguda2008]

一群狼啊

[--小F--]

---前后一一对应
说明：拷贝表(拷贝数据,源表名：a 目标表名：b) (Access可用) 
insert into b(a, b, c) select d,e,f from a; 

[feixianxxx]

-- =========================================
-- -----------t_mac 小编-------------------
   --------------------希望有天成为大虾---- 
-- =========================================

IF OBJECT_ID('A') IS NOT NULL
DROP TABLE A
GO
CREATE TABLE A( ID int ,loginId varchar(10),aaa INT,  bbb INT,  ccc INT,  ggg INT,  hhh INT )
go
insert A SELECT 

      1,            'My'     , 111 , 222 , 333 , 321,  123 UNION ALL SELECT 
      2,            'My'     , 222 , 333 , 444 , 456,  654 UNION ALL SELECT 
      3,            'You'    ,  222,  555,  444,  345,  543 UNION ALL SELECT 
      4,            'You'     , 111,  222,  555,  234,  432 UNION ALL SELECT 
      5 ,           'You'    ,  222,  333,  444,  232 , 324 
GO
IF OBJECT_ID('B') IS NOT NULL
DROP TABLE B
GO
CREATE TABLE B( ID int identity(1,1),aaa INT,  bbb INT,  ccc INT,  ddd INT,  eee INT )

go
insert into b(aaa , bbb, ccc , ddd , eee) 
select aaa , bbb, ccc , ggg , hhh 
from A 
where loginId = 'My'

SELECT * FROM B

ID          aaa         bbb         ccc         ddd         eee
----------- ----------- ----------- ----------- ----------- -----------
1           111         222         333         321         123
2           222         333         444         456         654

[xu_chenhao]

分不够呀

[guguda2008]

[Quote=引用 17 楼 xu_chenhao 的回复:]
分不够呀
[/Quote]
有正确答案了吗？

[xu_chenhao]

我的表1的ggg和HHH都不能为空怎么办？

[xu_chenhao]

[Quote=引用 6 楼 wufeng4552 的回复:]
SQL codeinsert tb(aaa,bbb,ccc,ddd,eee)select aaa,bbb,ccc,ddd,eeefrom awherewhere loginId='My'
[/Quote]
我表1的GGG和HHH都不能空怎么办？

[xu_chenhao]

[Quote=引用 13 楼 fredrickhu 的回复:]
SQL codeinsertinto
B(orderId,aaa,bbb,ccc,ddd,eee)select
id,aaa,bbb,ccc,ggg,hhhfrom
Awhere
loginId= My
[/Quote]我表1的GGG和HHH都不能空怎么办？