Of course it is posible. But a lot more information is needed before any more valid information can be supplied to you.

What about the second table? How do you decided what to get with the where clause of the SQL statement?

Can this data all be brought back at on time using Joins between table1 and table2 (INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN)?

What is supposed to written to the third table? What is the structure of that table? Where will the information be coming from to create that insert statement? Or will this be an Update statement to change a row that already exists in the third table?