I need to insert into a table ACCESS
some values from another table plus the time and the user who registered.
I know that to get the data from the other table just do something like:
INSERT INTO TABELA(ID, NOME, ENDERECO)
SELECT ID, NOME, ENDERECO FROM MEUBANCO2..MINHATABELA
WHERE ..
How do I also enter the time and user data in the same command INSERT
INTO, in addition to SELECT
(which is already getting some data from another table)?