RE: SQL UPDATE question

Why not only do: conn.beginTrans(); //Statments conn.commit(); or conn.rollback(); -Original Message- From: David Shanes [mailto:dshanes@;san.rr.com] Sent: October 31, 2002 12:12 To: [EMAIL PROTECTED] Subject: SQL UPDATE question Filter: SQL, UPDATE Is there a way to do the following

SQL UPDATE question

Filter: SQL, UPDATE Is there a way to do the following in one single statement? I know I can get all of the info from the three tables in a single query using joins... // Start a transaction conn.setAutoCommit(false); // Do the work. stmt = conn.createStatement(); // Update general acct info sS

SQL UPDATE question

Filter: SQL, UPDATE Is there a way to do the following in one single statement? I know I can get all of the info from the three tables in a single query using joins... // Start a transaction conn.setAutoCommit(false); // Do the work. stmt = conn.createStatement(); // Update general acct info sS