hi all

i am currently doing a project in vb.net , which needs to retireve values from two tables from the access database. The values i retrieved from the two tables need to be placed in an another table, which will contain the combined values..... IS it possible.. I tired it but could not get it........ it keeps on prompting "End of the statement needs (;)" but if i insert it it says "unknown characters found" so can someone help please.. it would be really great thanks
i have pasted my query here.please help!!!
Thnks in advance

insert into ftable (id,name,age,salary) values (s.id,s.name,s.age,m.salary) FROM s,m WHERE s.id = n.id AND n.salary = 2500

cheers
Newbie