DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000
    Hi All,
    I need sql statement which shows the difference between two tables.Say i have table a and table b.Ok.By comparing on column in a and another in b i should display all the records which doesnt match.Assume that i have 5000 records in table a and 6000 records in table b.so i want to see that are the records that doesnt match...please post sql statement....its very urgent...if i specify <> condition is doesnt give me the correct result.

    Thanks and Regards,

  2. #2
    Join Date
    Oct 2000
    Use the minus command, so it may be like

    select *
    from tablea
    select *
    from tableb


Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.