i have 2 tables each 1 have diff colum diff data each table have primary key
i want 2 insert the data to 3rd table. 3rd tble have same colum (tb1&tb2)
wen i inserting data into tb1 tb2 .the insert value should update table 3 i try this code
i dont know wat im wrong
INSERT INTO AccType SELECT Login.*,col1,col2,col3 FROM Login,Verify WHERE Login.Username="+Label2.Text+" AND Verify.Username="+Label2.Text+""
">
username is primary
im using sql2008
Acctype table contains username,pass,emailid,address,mobile: all columns varchar(50)
login tbl hav username,pass,address all columns varchar(50)
verify tble hav username,emailid,mobile all columns varchar(50)