[Solved] Is there a way of joining 2 tables and verify the data they have
You need to revisit your table design for sure. I am not very clear what you are looking for, but i feel that you are looking for entires in the derived table for which one or more values are null. For this scenario you can write query like following. select distinct mt.mainid from maintable mt … Read more