Hi all. I have 3 tables as following: PRODUCTS id | brand | model 1 | 1 | duron 2 | 1 | athlon64 3 | 2 | pIV
BRANDS id | brand 1 | amd 2 | intel NEW_PRODUCTS id | product_id 1 | 2 What I am trying to do is: Select products and join brand, but only products that are not new products. What I have is: ( SELECT products.id, products.model FROM products, brands WHERE products.brand = brands.id ) UNION ALL ( SELECT products.id, products.model FROM products, new_products WHERE products.id != new_products.product_id ) But I get too many results, repeated results, and I only have 20 entries in the original database. Any help would be appreciated! * Happy New Year! * Pedro Almeida. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
