How to compare two tables, and insert values which r not in one table to another table?

How to compare two tables, and insert values which r not in one table to another table?

Hi

I need to compare two tables MainTable and OUTTable, The maintable may not have all the data so...if outtable have new data just insert the values to main_table...

here is my sql query

insert into Main_Table MT (MT.serialno) values (Select SerialNo Main_Table MT from where not exists (select SerialNo from OUT_Table OT where OT.SerialNo = MT.SerialNo));

here is my code:

<%@ page import="java.sql.*" %>
<% Class.forName("oracle.jdbc.driver.OracleDriver");%>
<HTML>

    <BODY bgcolor="#99CCFF">
        <p>&nbsp;</p>
<p><img src="SingtelLogoBanner.gif" width="87" height="25"> </p>
<center>
<td align="right" width=37> <strong><img title="Go back" src="Undo.gif" width="20" height="20" onClick="javascript:history.back()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';"></strong>
<td align="right" width=38> <strong><img title="Print it" src="Print.gif" width="20" height="20" onClick="javascript:window.print()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';">
        </strong>
</center>
<H1 align="center">Inventory</H1>
        <%

        String connectionURL = "jdbc:oracle:thin:@localhost:1521:scott";
        String driver = "oracle.jdbc.driver.OracleDriver";
        String user = "root";
        String pass = "root";
        Connection connection = null;
        PreparedStatement pstatement = null;
        ResultSet resultset;
        int i = 1;

            Class.forName(driver).newInstance();
           connection = DriverManager.getConnection(connectionURL,user,pass);



             String queryString = ("insert into Main_Table MT (MT.serialno) values (Select SerialNo from Main_Table MT where not exists (select SerialNo from OUT_Table OT where OT.SerialNo = MT.SerialNo))");
             resultset = pstatement.executeQuery(queryString);
        %>

    </BODY>
</HTML>

This query is selecting all the values which r not in maintable...but not inserting into the main table using jsp. I am doing this program using JSP. Please can you give me the code to insert the values into maintable. Please help me out. Iam stuck here.

Thanks in advance Lissy.

View Answers

Ads









Related Tutorials/Questions & Answers:
How to compare two tables, and insert values which r not in one table to another table?
how to store array values into two different tables in java?
Advertisements
how to do two database tables in one page?
how to get values for same column name from two different tables in SQL
Join the two tables in sql
how to insert one table to anothere table
take data from one table and insert same in another
SQL Server row comparison using two tables
ModuleNotFoundError: No module named 'btc-yet-another-tables'
tables in oracle 10g
How to send and view data in seperate tables of a swing application, to a japser reporting(two)
How to send and view data in seperate tables of a swing application, to a japser reporting(two)
Comparing tables
search in Two Tables to Find data and view by jsp
merge tables in sql using union
update one table from another table
Joining tables using criteria
Combine Two Tables(Purchase and Sales) and getting Current Stock
Join tables in the specific database
how to count unique and duplicate values from one table in mysql?
copying data from one table to another
how to get multiple hyperlink values from a table column to another jsp file?
Mysql Join 3 Tables
I cant get values in MS acces in tables
what is the jsp coding to insert a data in database tables
how to insert the bulk data into the data base from the table of jsp page to another jsp page
how to compare text in two jTextarea
How to Dragging and dropping HTML table row to another position(In Jsp) and save the new position (values) also in database(MySql)?
How to include Two multi rows, one with a file Upload and another with normal fields, have problem while including both
Copy One Database Table to Another
Cross Join Tables in a Specific Database

Ads