1 Reply Latest reply: Jan 19, 2014 1:20 PM by Gysbert Wassenaar RSS

    How to show records where value in table A is not the same as value in Table B

    Marko Rakar

      I have a question;

       

      You have two tables:

       

      Table A which have Unique_ID and numeric value, and Table B which have Unique_ID and numeric value.

      Database have some additional fields and connected tables but they are not important for the problem.

       

      Idea would be to create view which will show me ONLY records where numeric value in table A is not the same as numeric value in Table B (as an extension I am also interested to see sets of data which will select records in which numeric value in one table is either greater or smaller then value in second table).

       

      Am I missing something obvious?