java.sql.SQLException-Need help to resolve.

[Jaidev Arer]

Hi,
I am using mysql database.
I have loaded the temp table with user info from the registration screen. If the user is approved, i need to load the base table with the pre-loaded data from the temp table.
email-id is the username so i am doing the check against it.
But i am getting
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where EMAIL_ADDRESS='[e-mail]'' at line 1
DAO-Function to insert the data from temp table to base table.

   public void customerapproved(String email_address) throws SQLException 
{
		int count=0;
	     try
		 {
		 	PreparedStatement p;
		 	getconnection();
		 	System.out.println("Logic under development 3");
			p = conn.prepareStatement("insert into oxy_customers (effective_start_date,effective_end_date, first_name, last_name, address_line1, address_line2, landmark, area, city, state, pin_code, home_phone, mobile_phone, DEFAULT_LITRES_PER_DAY, EMAIL_ADDRESS, EMAIL_PASSWORD, CUST_LAST_LOGIN) select effective_start_date,effective_end_date, first_name, last_name, address_line1, address_line2, landmark, area, city, state, pin_code, home_phone, mobile_phone, DEFAULT_LITRES_PER_DAY, EMAIL_ADDRESS, EMAIL_PASSWORD, CUST_LAST_LOGINfrom oxy_temp_customers_itf where EMAIL_ADDRESS='"+email_address+"'");
			System.out.println("Logic under development 4 ");
			count = p.executeUpdate();
		 	p.close();
	 	}
	 	catch(Exception e)
	 	{
	 		System.out.println(e);
	 	}
	 	System.out.println("count is "+count);
} 

[Jan Cumps]

Look at this part of your query: CUST_LAST_LOGINfrom

Regards, Jan