Anishgiri
07-07-2011, 02:58 AM
Suppose I have table1 and table2, table2 is exact duplicate of some table rows in table1. When table1 get new record, how can I insert the new record on table2. I know you can use the insert to put the new record of table1 to table2. But what I want is to check table1 if there are records that is not on table2, and if it does, insert that record on table2.
To make it more clear table1 one has fname, lname and country fields and table2 is the duplicate of table1, but table2 does not have the country fields. What I want is if table one get new record, the new fname and lname record will be also inserted in table2.
Below is q query i just not now how to continue it.
SELECT fname,lname
INTO table2
FROM table1
WHERE fname
To make it more clear table1 one has fname, lname and country fields and table2 is the duplicate of table1, but table2 does not have the country fields. What I want is if table one get new record, the new fname and lname record will be also inserted in table2.
Below is q query i just not now how to continue it.
SELECT fname,lname
INTO table2
FROM table1
WHERE fname