Insert...Select

Database
N/A

Insert...Select

i need full syntax of Insert...Select Statement?
1 REPLY
Fan

Re: Insert...Select

its simple

INSERT INTO TABLE_NAME_1
SELECT FIELD_1,...,FIELD_N
FROM TABLE_NAME_2
WHERE CONDITION EXPR(specify constraints if any)