samedi 2 janvier 2021

How to fetch record from Table A which has not any approved status true on Table B

I have three table A , B and C and it structure is shown below

            Table A                        
   ----------------------------         
   | id | Text_message_to_show|
   ----------------------------
   | 1  | first demo message  |
   ----------------------------
   | 2  | second demo message |
   ----------------------------


               Table B
   ------------------------------------
   | id | request_id  | approved_status |        
   ------------------------------------
   | 101  |   1      |       2        |
   ------------------------------------
   | 102  |   1      |       1        |
   ------------------------------------ 
   | 103  |   2      |       2        |
   ------------------------------------ 
   | 104  |   2      |       2        |
   ------------------------------------   

                Table c
   ------------------------------------
   | id | request_id  | approved_status |        
   ------------------------------------
   | 501  |   1      |       2        |
   ------------------------------------
   | 502  |   2      |       1        |
   ------------------------------------  
  
   

Table B and Table C has foreign key request_id column which is reference id column of table A.Table Table A-> Table B has one to many relaionship and Table A->Table C has one to one relationship Now I have question is how to wrie sql query such that to fetch Table A record where no approved_status for request_id should be 2 in Table B And also Table C approved_status should not be 2



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire