I am trying to write an insert query that will look at a table (table1) and insert values into a new table (Table2) based on that original table (Table1). In table1 I want to look at the BLF_Election field and if it is a 1 I want to put the letters BLF into a field in table 2, if it is not a 1 I want to put nothing.
This seems like it would be pretty simple. and I tried this code
IF(table1.BLF_Election = 1) , BLF, '')
However that didn't seem to work. Can anyone assist?