How to show records where value in table A is not the same as value in Table B
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).
Re: How to show records where value in table A is not the same as value in Table B
Use Unique_ID as dimension and as expression if(FieldA<>FieldB,1). If you want the records where FieldA is larger then FieldB simply adjust the clause in the if statement: if(FieldA>FieldB,1). In a straight table you can hide the expression if you want.