Updating multi tables

Friends,

I'm looking for a way to update the multi tables with an sql statement with an condition

Set connRE = Server.CreateObject("ADODB.Connection")
myDSN="DSN=DNS;User Id=user;password=password"
connRe.Open myDSN


sqltemp= "Insert into table1 (field1, field2) values(value1, values)
//lost right here
//If value not in table 2 than insert the field into the table.
insert into table2(field1, field2) values(value1, values)




set rstemp=connRE.execute(sqltemp)

set rstemp=nothing

connRE.close
set connRE=nothing