Thanks for replying.
I tried that query but I get the following error:
Query failed : You have an error in your SQL syntax...
... right syntax to use near 'EXISTS ( SELECT * FROM new_products t03 WHERE
t03
I think I will have to forget the join, split and do a compare directly in
php.
Also, I want to get n random unique results from a query, can it be done
using sql?
Pedro Almeida.
-----Mensagem original-----
De: Alex S Moore [mailto:asmoore@stripped]
On Wed, 29 Dec 2004 19:57:04 -0000
"mail.pmpa" <mail.pmpa@stripped> wrote:
> 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 )
SELECT t01.id, t01.model
FROM products t01 JOIN brands t02
ON t01.brand = t02.id
WHERE NOT EXISTS (
SELECT * FROM new_products t03
WHERE t03.product_id = t01.id)
Alex
