problemer med select og insert

INSERT INTO tabele1 SELECT .. FROM Tabel2

You have to do it one table ata time unless you make a untion join on tabel2 and table3

How do I do it with both tables - could you show me the join?

SELECT fld1, fld2 FROM tabel1
UNION ALL
SELECT fld1, fld2 FROM tabel2

You may need to save this as a query and then use the query in the INSERT INTO....

Like this:

INSERT INTO NyTabel
SELECT [tabel1].kundenummer, [tabel1].landekode, [tabel1].emailadresse, [tabel1].emailkode FROM [tabel1]
UNION JOIN
SELECT [tabel2].kundenummer, [tabel2].landekode, [tabel2].emailadresse, [tabel2].emailkode FROM [tabel2]
WHERE ((([tabel1].kundenummer)<>[tabel2].[kundenummer] Or ([tabel1].kundenummer)<>[tabel3].[kundenummer]));

Access is saying "santax error" where "UNION ALL" is...

No!
Make a query in Access where you use the UNION

then use query instead of the two table

I dont get it...

IN access you can make a query, do you know how to do this?

In the query designer select SQL view and the copy the SQL for the UNION JOIN into the query. You MUST NOT use the WHERE in the UNION join
>>>
SELECT [tabel1].kundenummer, [tabel1].landekode, [tabel1].emailadresse, [tabel1].emailkode FROM [tabel1]
UNION JOIN
SELECT [tabel2].kundenummer, [tabel2].landekode, [tabel2].emailadresse, [tabel2].emailkode FROM [tabel2]

save the query as qryUNIONALL

NOW you can make your INSERT query

something like

INSERT INTO .....
SELECT .... FROM qryUNIONALL WHERE ....
[tabel1].kundenummer NOT in (SELECT kundenummer FROM qryUNIONALL)




Now you need to find out which records do not exist in tabel1. You can use the query wizard for doing this.

Hello again!

Now I can see what you mean - it seems like it is working - thank you!