How to find missing records with mysql?07.12.13

example you have product and product description tabel but there are some records for the product description talbe missing. to find now those missing descriptions you can use the following mysql command: SELECT products_id FROM products p WHERE NOT EXISTS ( SELECT * FROM products_description pd WHERE p.products_id = pd.products_id ) 07.12.13

http://dbaspot.com/forums/sqlserver-programming/188325-sql-find-missing-record-comparing-2-tables.html

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024