Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    2

    Unanswered: compare two tables

    Hey guys,
    so i have two tables with date's attached to each row. But in table A there are 10 more rows than in table B. I need to find where the dates of the two tables do not match up; aka i need to find unique date values between the two tables. ive tried different select with distinct modifiers but have yet to come up with a solution. Any help would be great

  2. #2
    Join Date
    May 2008
    Posts
    277
    Showing some sample data with expected output would help.

  3. #3
    Join Date
    Jun 2011
    Posts
    2
    thanks for the offer but i figured it out.
    I used a LEFT OUTER JOIN on the date columns of each and just scanned the results for discrepancies

Posting Permissions

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