List:General Discussion« Previous MessageNext Message »
From:Chris Date:May 26 1999 11:23am
Subject:Re: Embedded select
View as plain text  
> 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.
> 


Thread
Embedded selectSandrine C.26 May
  • Re: Embedded selectChris26 May
    • Re: Embedded selectErik Liljencrantz26 May
    • Re: Embedded selectJames Rogers27 May
      • Re: Embedded selectMichael Widenius2 Jun
RE: Embedded selectGert van 't Hof26 May