Comparing Oracle Table Row Values

Jul 12, 2012 at 9:12 PM
Edited Jul 12, 2012 at 9:38 PM

Hi everybody, I'm a new programmer.

My first project is to create a webpage to show the discrepancies of Store Transactions Report.

Database :Oracle 9i 

Programming Language:C#

Two Tables that needed to be match :

Table A (Column Names: Amount,Date,Time,Store_Number)

Table B (Column names are the same with Table A)

Procedure : Select Table A and Table B, find the unmatched Data and insert in Table C (same column names with Table A& B).

How do I match the values of each row using C# codes? 

Developer
Jul 12, 2012 at 11:39 PM

hi Scott,

I would suggest you try and posting your question on http://stackoverflow.com/

As you'll get a quicker and more details response to your question.

My guesses is something like this? http://stackoverflow.com/questions/3186818/unique-list-of-items-using-linq

Good luck on your search.

Jul 13, 2012 at 2:40 PM

Thanks for responding Akronite!