How to retrieve data from multiple tables using laravel query building

Asked Jun 02 '16 at 06:46

Active Jun 02 '16 at 07:51

Viewed 100 times

I have 2 records in each table. when i tried this below query

$result = DB::table('table1')
          ->join('table2','table1.user_id','=', 'table2.user_id')
          ->join('table3','table1.user_id','=', 'table3.user_id')
          ->join('table4','table1.user_id','=', 'table4.user_id')
          ->select('table1.*','table2.email','table3.*','table4.*')
          ->get();

i got the repeated data from the last table alone and also i couldn't get the data from first three tables

I need an output like this

--------------------------------
id      email           user_id
--------------------------------
1       aaa@test.com    40
2       bbb@test.com    40
1       ccc@test.com    40
2       ddd@test.com    40
1       eee@test.com    40
2       fff@test.com    40
1       ggg@test.com    40
2       hhh@test.com    40
--------------------------------

edited Jun 02 '16 at 07:51

asked Jun 02 '16 at 06:46

Arunkumar

You didn't define the fields that you were looking for simply use `select` within the eloquent – Narendrasingh Sisodia Jun 02 '16 at 06:52
still it remains to show the same @Uchiha – Arunkumar Jun 02 '16 at 06:55
Define specific fields it seems you have used `inner join` over here and you might have that much understanding what output you were looking for, or you simply post your Table Schema with expected output – Narendrasingh Sisodia Jun 02 '16 at 06:57
i have 2 records in each table and each table have field "user_id" I need an output to display all the records from all the table @Uchiha – Arunkumar Jun 02 '16 at 07:12
you need to add a groupby('table1.user_id') – astroanu Jun 02 '16 at 07:42
no i want to display data from all the tables @astroanu – Arunkumar Jun 02 '16 at 07:54
to prevent repeated rows you need to group them by something :) you can create a new column name 'group' by concatenating two values from different fields then groupBy('group') – astroanu Jun 02 '16 at 08:07
Not only about repeating data, I couldn't retrieve data from first 3 tables. @astroanu – Arunkumar Jun 02 '16 at 08:16
I am getting data from fourth table alone repeatedly @astroanu – Arunkumar Jun 02 '16 at 08:19
Not sure if that is the issue, but if the column names are same in all those tables, repeated columns with same name won't appear – hashbrown Jun 02 '16 at 08:44
but i dont why only single table data alone displaying leaving other 3 tables – Arunkumar Jun 02 '16 at 08:48

How to retrieve data from multiple tables using laravel query building

0 Answers0