Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    24

    Unanswered: How do you compare the data in two tables

    I have two tables and I want to find out if:

    1. There are missing rows in any of the tables
    2. If the rows that are present in both tables contain absolutely the same data

    Any suggestions for a short way to do this?

    Thank you!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    wow, this must be a homework question, because we answered it just last week

    1. full outer join, test key fields for nulls
    2. equi-join

    that's as much of a hint as i will give you

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •