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.
