使用CASE和左连接时出现MySql错误

I have three tables table1, table2 and table 3. I am getting data to a file with sequence of the output as shown below. I want to append the data coming in that file to a table4 that ill create and persist using Java.I have three tables table1, table2 and table 3.