> I try to do an embedded selct that doesnt work
> here ar emy tabels and the syntax I am using. Can anybody see what's wrong
> with it?
Hi Sandrine, MySQL doesn't support nested selects at this time.
--Chris
> select * from produit where
> (OR_Code = ('select * from organisme where OR_Raison='CAFAL' '));
>
>
> TABLE PRODUIT :
>
> +-------------------+--------------------------------------+------+-----+---------+----------------+
> | Field | Type | Null | Key |
> Default | Extra |
>
> +-------------------+--------------------------------------+------+-----+---------+----------------+
> | PR_Code | varchar(8) | | PRI |
> | auto_increment |
> | OR_Code | varchar(8) | | MUL |
> | |
> | PR_NomProd | varchar(100) | | |
> | |
> | PR_Resume | text | YES | |
> NULL | |
> | PR_Proposition | blob | YES | |
> NULL | |
> | PR_Etat | enum('actif','inactif','en attente') | YES | |
> NULL | |
> | PR_DateCre | date | YES | |
> NULL | |
> | PR_DateMAJ | date | YES | |
> NULL | |
> | PR_DateActu | date | YES | |
> NULL | |
> | PR_DateValid | date | YES | |
> NULL | |
> | PR_TaillEntMin | int(11) | YES | |
> NULL | |
> | PR_TaillEntMax | int(11) | YES | |
> NULL | |
> | PR_GrpAppart | enum('','Y','N') | | |
> | |
> | PR_GrpMin | int(11) | YES | |
> NULL | |
> | PR_GrpMax | int(11) | YES | |
> NULL | |
> | PR_CreaEntrMin | int(11) | YES | |
> NULL | |
> | PR_CreaEntMax | int(11) | YES | |
> NULL | |
> | PR_CreaEntDateMin | date | YES | |
> NULL | |
> | PR_CreaEntDateMax | date | YES | |
> NULL | |
> | PR_CAMin | int(11) | YES | |
> NULL | |
> | PR_CAMax | int(11) | YES | |
> NULL | |
> | PR_SituFin | enum('','saine','non saine') | | |
> | |
> | PR_EmplReg | blob | YES | |
> NULL | |
> | PR_EmplNat | blob | YES | |
> NULL | |
>
> +-------------------+--------------------------------------+------+-----+---------+----------------+
>
> TABLE ORGANISME
>
> +-------------------+-------------------------------------------+------+-----+------------+----------------+
> | Field | Type | Null | Key
> | Default | Extra |
>
> +-------------------+-------------------------------------------+------+-----+------------+----------------+
> | OR_Code | varchar(8) | | PRI
> | | auto_increment |
> | OR_Raison | varchar(40) | |
> | | |
> | OR_Libelle | varchar(50) | YES |
> | NULL | |
> | AD_Adresse | varchar(8) | YES |
> | NULL | |
> | OR_Statut | enum('','Prive','Public') | YES |
> | NULL | |
> | OR_Implementation | enum('','Nationale','Regionale','Locale') | YES |
> | NULL | |
> | CO_Directeur | varchar(8) | YES |
> | NULL | |
> | CO_InterlPrinc | varchar(8) | YES |
> | NULL | |
> | OR_Etat | enum('Actif','Inactif','En Attente') | |
> | Actif | |
> | OR_DateMAJ | date | |
> | 0000-00-00 | |
>
> +-------------------+-------------------------------------------+------+-----+------------+----------------+
> 10 rows in set (0.05 sec)
>
>
>
> Thank you
> Sandrine
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3950@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
