Help with a sql query

[batteryman]

Hello,

I have been trying to delete a bunch of wanted products and I keep getting strange results. What am I doing wrong.

I narrowed down my products to a specific manufacture which was easy but now I am trying to update the other tables to reflect the same information and isnt working. Here is what I am using.

select pd.* from products p, products_description pd where p.products_id != pd.products_id;

Basically I have a 1000 products in my products table and I want to get rid all of the old product description that are no longer needed. So i am doing a comparison to the products category. The result I get it really weird.

Here is the actual result:

Showing rows 0 - 29 (3,268,000 total, Query took 0.0245 sec)

It repeats each product description hundreds of times. How can I fix this to give me accurate results so I can delete the excess rows of old product descriptions?

[batteryman]

I really could use some help with my questions