I am trying to insert records into a table based on a where clause on a different table.
Can you please help me with this.
Hard to help without seeing some of your code.
Unless you are doing a insert into <tblname> select .....MySql doesn't allow you to do this.
