@@ -123,14 +123,14 @@ |
||
| 123 | 123 | $users = DB::table("users as u") |
| 124 | 124 | ->selectRaw("u . id as usuario, sub . street as rua") |
| 125 | 125 | ->leftJoinSub($address, 'sub', "sub . user_id = u.id AND 1 = ?", [1]); |
| 126 | -var_dump($users->get());die; |
|
| 126 | +var_dump($users->get()); die; |
|
| 127 | 127 | |
| 128 | 128 | /** |
| 129 | 129 | * Selecionar de uma subquery |
| 130 | 130 | * |
| 131 | 131 | * Select * from (select * from users) as sub |
| 132 | 132 | */ |
| 133 | -$dados = DB::fromSub(function (Query $query) { |
|
| 133 | +$dados = DB::fromSub(function(Query $query) { |
|
| 134 | 134 | return $query->from("users")->selectRaw('first_name')->limit(10); |
| 135 | 135 | }, 'sub') |
| 136 | 136 | ->order('first_name')->groupBy(['first_name']); |