This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have the following 2 tables which I need to compare and identify the incorrect mapping records. The challenge is the mapping schemes are different between those 2 tables. Table A is the "should be" table, where all records are explicit, or one-to-one relationship. On the other hand, Table B, which is the table potentially with incorrect records, uses BETWEEN and IN to store the mappings. What is the best way to go about this? Thank you for your help.