multiple tabel queries

[mavog]

Hi All,
i have 2 old tables imported into a new database that i want to append to 2 new tables in the new db. the 2 old tables are "Client" and "History". Client has a 1-many relation with History. I want to discard most fields of the old but i do want to keep the "Client name" and all "history comments" in the new tables.
Client has fields: ID(Index), Name, Address, (and more).
History has fields: HIndex, [contacted by], date, ID(relation to client),Comment (and more).
The new tables i want to populate are
CompdetailCIndex, activitylink, name,and other new fields
and Activity AIndex, complink, Note, followup,activitytype.
i know the query starts with INSERT INTO ,but it gets a bit cloudy after that.
Could somebody please help me with some suggestions how i can achieve this

 

[substitute]

As you are posting in the Access forum, and evidently are not very familiar with SQL, why don't you use Access to write your SQL for you.

If you set up an appropriate Append query in the query design window Access puts the equivalent SQL in the SQL window.