I have three table A,B,C And Structure Is Shown Below
Table A
----------------------
|id | text_message |
----------------------
|1 | first Message |
----------------------
|2 | second 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 | 1 |
----------------------------------------
|502 | 2 | 2 |
-----------------------------------------
1)Table B request_id column is foreign key reference Table A id column
2)Table C request_id column is foreign key reference Table A id column
3)Table A has one to many relationship with Table B
4)Table A has one to one relationship with Table C
How to write eloquent query so that We can get all record from Table A and Table C and distinct record i.e distinct request_id from Table B
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire