MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
NOT IN synthax in mysql
3048
montreal montreal
March 14, 2005 12:32PM
Re: NOT IN synthax in mysql
2131
Mark Leith
March 15, 2005 08:41AM
Exception Handaling in stored procedure
2294
Shalmi Patel
May 23, 2005 06:17AM


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.