I've got two tables A and B, both with indentification field ID. I want to merge them.
Table B has some fields (say a, b and c) which I want to copy into table A, resulting in a complete table A, after which I can delete table B.
The data of table B record with ID XXX must of course be copied to the corresponding record in table A with the same ID XXX.
The SQL statement I try to use is:INSERT INTO A (a, b, c)
SELECT a, b, c
FROM B
WHERE B (ID) = A (ID);
But this causes an error "The expression contains an undifined function B"
After trying several things, I concluded that the B refers to the B in WHERE B (ID) = A (ID)
How can I get this done?
Can it be done in a single query? Or should I use a differrent approach?
Any help is much appreciated.
Frank