MySQL Forums
Forum List  »  InnoDB

NOT IN synthax in mysql
Posted by: montreal montreal
Date: March 14, 2005 12:32PM

Hi,

does anybody know how to write this in MySql language :

SELECT COUNT(id_client) AS nouveaux_client FROM commande WHERE date_cde BETWEEN '".$date1."' AND '".$date2."' AND id_client NOT IN (SELECT id_client FROM commande WHERE date_cde < '".$date1."')

Thanks in advance !

Monty

Options: ReplyQuote


Subject
Views
Written By
Posted
NOT IN synthax in mysql
2963
March 14, 2005 12:32PM
2086
March 15, 2005 08:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.