ResultSet Function deleteRow() : PLEASE HELP!!
Following is a code i am working on :-
There are two tables Model and Stud. The two tables are beng compared and all the words that are similar in both the tables are inserted in another table called Compare, at the same time i wish to delete the words from both the Stud and Model tables. The function deleteRow() works fine when the select statement has only one table , but how to work it out for complex select statements for multiple tables.
public class deleteRowDemo
public static void main(String args)
rs=stmt.executeQuery("select Mword, from Model,Stud where Mword=Sword");
ps=con.prepareStatement("insert into Compare (Cword) values (?)");
Re: ResultSet Function deleteRow() : PLEASE HELP!!
Please don't double post; I'm closing this thread and answered your question in your other thread (in the 'new to java' forums).