I am trying to do a simple append query to update a table. What I am trying to achieve is update a table when changes have been made to the table that I am appending from.
INSERT INTO TransactDetail
SELECT *
FROM Trans;
I would like to put a WHERE clause in
WHERE Trans.trdreferenceNo > TransactDetail.trdreferenceNo
This however does not work.
trdreferenceNo is a primary key.
Any help will be fantastic
INSERT INTO TransactDetail
SELECT *
FROM Trans;
I would like to put a WHERE clause in
WHERE Trans.trdreferenceNo > TransactDetail.trdreferenceNo
This however does not work.
trdreferenceNo is a primary key.
Any help will be fantastic