Insert into table the selected columns from another table [duplicate]

Question

What query would insert the selected columns, for a desired value, from a table into another table?

Before Query

table1=>Colums(A,B,C)
  row1(a,b,1)
  row2(c,d,0)
  row3(e,f,1)

table2=>Columns(id,A,B)

After Query

table1 is unchanged.

table2(id,A,B)
  row1(id,a,b)
  row2(id,e,f)

I need to insert in table2 all the rows from table1 where 'C=1', C may equal 1 in multiple records.

Answer 1

INSERT INTO TABLE2(A,B,C)
SELECT A,B,C
FROM TABLE1
WHERE C = 1