Comparing 2 tables

Hi All

I need to compare 2 tables ( I need to eliminate 2 columns in the
table while comparing, they are dates and userids which wil be
different. )

Example:

TableA( colA, colB, colC, colD, colE)
TableB( colA, colB, colC, colD, colE)

I need to compare TableA and TableB , for me they are equal if
contents of colA, colB, colC are same , need not compare colD and
colE.

I write jdbc program which reads tables and compare row by row, just I
think it is laborious. Is there a better way of doing this. Please let
me know.

Thanks
.

Relevant Pages

  • Re: Gas and Electric usage up since new windows installed
    ... > Have you done the obvious and compared the weather from last year to this ... > a lot colder this year, you're going to see higher utility bills. ... > can't compare ... Here in CT, it seems very cold, but we are still behind ...
    (alt.home.repair)
  • Re: Edame beans...
    ... I had some from a salad bar a couple of weeks ago, cold. ... I would compare them to peas. ...
    (rec.food.cooking)
  • RE: Comparing data in columns and delete if not equal
    ... Then tell what you are comparing ColA and ColB or ColD and ColZ. ... up to start on the first value to compare and then compare it to the nest ...
    (microsoft.public.excel.programming)
  • Re: Our Splodge isnt there yet, is she?
    ... Here's an example of how cold it might be ... enjoyed my pictures" ... that time so I have lots of photos to be able to compare yours with :-) ... Pam the goose ...
    (uk.people.silversurfers)
  • Re: Do they have Save Paris tee shirts yet?
    ... compare a Paris Hilton shirt to a cheesehead--gasp)- ... Suddenly I feel cold. ... stitches @ singerlady.reno.nv.us.earth.milky-way.com ...
    (rec.arts.mystery)