SQL Statement

[Harine]

Hi.. i'm new to JSP. i'm currentli tryin to compare two tables in mysql and reflect the difference.

i used the code below but when i display it..nothing is being reflected.Please do help and guide me.Thank you.

String sql = "Select * from examinerdb where NOT EXISTS(SELECT * from dbexaminer where dbexaminer.ModuleCode=examinerdb.ModuleCode)";

   while (rs.next())
    {
        String varModule=rs.getString("ModuleName");    
        String varCode=rs.getString("ModuleCode");


        out.print(varModule);
        out.print(varCode);




    }
     // close the resultset and statement   
     rs.close();
     rs = null;

     stmt.close();
     stmt = null;

}

[Stefano Mtangoo]

You definitely need this tutorial

[Harine]

Thank you..:)