Mysql question

[spr1nt]

both the products table and products_description table share products_id column. however, i deleted some of the rows from the products table so now my products_descripition table has more products_id then my products table. how do i compare the 2 tables and show just the products_id that dont match from products_descripition table?

 

SELECT products.products_id, products_description.products_id FROM products, products_description WHERE products.products_id != products_description.products_id;

 

i tried that query but that doesnt do what i want because it ends up giving me 2 columns of results when i just want one. anyone have any ideas?