How to write conditional select insert statement , to fetch record from a table, and based on some particular columns values : for eg:
1) Table1 --c1,c2,c3 (1,10,123)
2) Table2 --c1,c2,c3,c4
Now i want to select record from table1 and if c3 column value starting two digit is 12 then i have to populate AA, in Table2 c4 column.
 Table1 -- (1,10,123)
 Table2 --(1,10,123,AA)