Hi friends

      I have to update a table name Mismatch, The query name is QtrTxble

__________________________________________________ _________________________

SQL QUERY

INSERT INTO Mismatch ( Mismatch.row, Mismatch.SSN, Mismatch.QtrTxble, Mismatch.YtdTxble, Mismatch.QtrAmt, Mismatch.YtdAmt, Mismatch.QtrGross, Mismatch.YtdGross )
SELECT File1.row, File1.SSN, File1.QtrTxbl, File1.YtdTxbl, File1.QtrAmt, File1.YtdAmt, File1.QtrGross, File1.YtdGross
FROM FILE1 INNER JOIN File2 ON File2.SSN=File1.SSN
WHERE ((File1.QtrTxbl)<>(File2.QtrTxbl)) AND ((File1.YtdTxbl)=(File2.YtdTxbl)) AND ((File1.QtrAmt)=(File2.QtrAmt)) AND ((File1.YtdAmt)=(File2.YtdAmt)) AND ((File1.QtrGross)=(File2.QtrGross)) AND ((File1.YtdGross)=(File2.YtdGross));
__________________________________________________ _________________________


Error :

The INSERT INTO statement contains the following unknown field name:'Mismatch.row'. Make sure you have typed the name correctly

__________________________________________________ _________________________


Table Mismatch structure
row (key) Number
SSN Text
QtrTxble "
YtdTxble "
QtrAmt "
YtdAmt "
QtrGross "
YtdGross "
__________________________________________________ _________________________

Table File1 Structure

row (key) Number
Key1 Number
SSN Text
QtrTxble "
YtdTxble "
QtrAmt "
YtdAmt "
QtrGross "
YtdGross "
__________________________________________________ _________________________

Table File2 Structure

row (key) Number
Key1 Number
SSN Text
QtrTxble "
YtdTxble "
QtrAmt "
YtdAmt "
QtrGross "
YtdGross "

 Please help me , where i am wrong?
__________________________________________________ _________________________


Thanks and Regards
Lawson, COBOL

__________________
Thanks and Regards
Lawson, COBOL

Hi friends i figured it out

SQL QUERY

INSERT INTO Mismatch ( MISTAKE ( table name mismatch should not be there )--> Mismatch.row, Mismatch.SSN, Mismatch.QtrTxble, Mismatch.YtdTxble, Mismatch.QtrAmt, Mismatch.YtdAmt, Mismatch.QtrGross, Mismatch.YtdGross )
SELECT File1.row, File1.SSN, File1.QtrTxbl, File1.YtdTxbl, File1.QtrAmt, File1.YtdAmt, File1.QtrGross, File1.YtdGross
FROM FILE1 INNER JOIN File2 ON File2.SSN=File1.SSN
WHERE ((File1.QtrTxbl)<>(File2.QtrTxbl)) AND ((File1.YtdTxbl)=(File2.YtdTxbl)) AND ((File1.QtrAmt)=(File2.QtrAmt)) AND ((File1.YtdAmt)=(File2.YtdAmt)) AND ((File1.QtrGross)=(File2.QtrGross)) AND ((File1.YtdGross)=(File2.YtdGross));

so it should be

INSERT INTO Mismatch (row,SSN,QtrTxble,YtdTxble,QtrAmt,YtdAmt,QtrGross, YtdGross )
SELECT File1.row, File1.SSN, File1.QtrTxbl, File1.YtdTxbl, File1.QtrAmt, File1.YtdAmt, File1.QtrGross, File1.YtdGross
FROM FILE1 INNER JOIN File2 ON File2.SSN=File1.SSN
WHERE ((File1.QtrTxbl)<>(File2.QtrTxbl)) AND ((File1.YtdTxbl)=(File2.YtdTxbl)) AND ((File1.QtrAmt)=(File2.QtrAmt)) AND ((File1.YtdAmt)=(File2.YtdAmt)) AND ((File1.QtrGross)=(File2.QtrGross)) AND ((File1.YtdGross)=(File2.YtdGross));

Thanks and Regards
Lawson, COBOL