It's working now!
Thank you Shawn and Alex.
Have a Happy New Year!
Pedro Almeida.
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviada: quarta-feira, 29 de Dezembro de 2004 21:23
Para: mail.pmpa
Cc: mysql@lists.mysql.com
Assunto: RE: SQL UNION ALL
"
"mail.pmpa" <[EMAIL PROTECTED]> wrote on 12/29/2004 03:52:10 PM:
> 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 thi
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 w
On Wed, 29 Dec 2004 19:57:04 -
"mail.pmpa" <[EMAIL PROTECTED]> 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
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 pr
