Thread:

From
"Mark G. Franz"
Date:
Yes I'm a newbie...
 
I need to do a nested UPDATE to 2 tables, will this work?  (and no I didn't try it... production server)
 
st.executeUpdate("INSERT INTO Registration(ExpirationDate), Customer(UserName, Password) VALUES (DATETIME(NOW()+" + days + "), "+ username +", "+ password +" WHERE Customer.CustomerID=Registration.CustomerID AND Registration.CustomerID=" + id + ")");
 
Don't worry to much about the variables and such... just the SQL string.
 
Thanks!