An enormous amount of data is being collected and used up by businesses around the globe. It is equally essential to manage the data properly and ensure its proper usage. Presently, SQL has been very crucial for accessing, updating,inserting, manipulating and modifying data. SQL Query to Find Missing Records between Two Related Tables: You can have a detailed understanding with the help of two database tables: eav_attribute_option table and eav_attribute_option_swatch table. However, here small amount of data is used but in case of daily lives, we have a significant amount of data. At times, necessity often arrives to determine missing data from related tables. At the time of migration from Magento 1 to Magento 2, there is certain amount of data is missing from the database. Here, eav_attribute_option table and eav_attribute_option_swatch table are default databases of Magento 2. That?s it!