cursor.execute("SELECT A.idnum , B.fname , B.clientname FROM sample_divya1 A , sample_divya3 B WHERE A.clientname = B.clientname")
data_1=cursor.fetchall()

for id,name,client in data_1:
    sql="select email,lname,@name from sample_divya_"+id
    cursor.execute(sql)
    data_2=cursor.fetchall()
    conn.commit()
    print data_2
    for email,namel in data_2:
       sql1="""insert into sql_table1  values ('%s','%s','%s') """ % ((email,namel,name))
       cursor.execute(sql1)
       data_3=cursor.fetchall()
       conn.commit()





Input Tables: Sample_divya1:

 +-------+------------+---
    | idnum | clientname |
    +-------+------------+-
    | 1234  | renold    |
    | 1235  | renold1    |
   +-------+------------+

**sample_divya3**
+--------+------------+
| fname  | clientname |
+--------+------------+
| saha   | renold     |
| hasini | renold1      |
+--------+------------+

sample_divya_1234

   +-------------------+----------+
    | email             | lname    |
    +-------------------+----------+
    | abc@yahoo.com     | abcd     |
    | bcd@gmail.com     | bcda     |
    +-------------------+----------+
    **sample_divya_1235**
    +------------------+-----------+
    | email            | lname     |
    +------------------+-----------+
    | xyz@gmail.com    | xyza      |
    | nag@gmail.com    | sai       |
    | hij@gmail.com    | klm       |


output:

+------------------+----------+--------+
| email            | lname    | fname  |
+------------------+----------+--------+
| abc@yahoo.com    | abcd     | saha   |
| bcd@gmail.com    | bcda     | saha   |
| xyz@gmail.com    | xyza     | hasini |
| nag@gmail.com    | sai      | hasini |
| hij@gmail.com    | klm      | hasini |
+------------------+----------+--------+