Eloquent or Query Builder Select all from multiple tables

Use an appropriate join.

https://laravel.com/docs/5.8/queries#joins

Aliases can be included in the query (even the redundant ones!), e.g.

DB::table('configurations as config')
    ->join('shoes as shoes', 'shoes.col1', '=', 'config.col1')
    ->//...

Hey @nanadjei2 You can try like:

Configuration::selectRaw('configurations.* as configs', 'shoes.* as shoes', 'categories.* as cats')
                ->where('configurations.product_id', '$product->id')        // Please use your relation
                ->join('shoes', 'shoes.config_id', 'configurations.id')
                ->join('categories', 'categories.shoe_id', 'shoes.id')
                ->get();

@tykus Config has no relationship with shoes. I just want separate tables with aliases no relationships needed.

@nanadjei2 Then you must take them in different variables and merge at last. Like:

$configs = Configuration::all();
$shoes = Shoe::all();
$mix = array_merge($configs, $shoes);

$cats = Category::all();
$data = array_merge($mix, $cats);

Or you could try:

$dataArr = [];
$configs = Configuration::all();
$shoes = Shoe::all();
$cats = Category::all();

$dataArr = [
    'configs'=> $configs,
    'shoes' => $shoes,
    'cats'  => $cats
];

This one might help you achieve the solution.

@nomguy configurations have no relationship with shoes. I just want the explicit tables and give them my aliases that's all.

@nanadjei2 Let me know if it helps. Thanks!

I was thinking there was a way to do it with Query Builder in other to join tables all at once. Thank you.

I was thinking there was a way to do it with Query Builder in other to join tables all at once.

You can do it with the query builder:

DB::select('SELECT * FROM configurations as configs, shoes as shoes, categories as cats');

For my interest, what is the intended result of this query?

No problem @nanadjei2 .Thanks!

Hey @tykus I believe what @nanadjei2 wanted to get was, if you have three tables with data. First Configuration table like:

'id' => 1,
'name'  => 'test'

Shoe table like:

'id'    => 1,
'name'  => 'dummy'

and Category table like:

'id'    => 1,
'name ' => 'demo'

All he wanted is data like:

[
    [configs]   => [
        [id]    => 1
        [name]  => test
    ],
    [shoes] => [
        [id]    => 1
        [name]  => dummy
    ],
    [cats]  => [
        [id]    => 1
        [name]  => demo
    ],
];

Something like this.

DB::select('SELECT * FROM configurations as configs, shoes as shoes, categories as cats');

   Mix the results up and don't have a specified key to hook onto.

Well, that was my point, the pseudo-query in the first post produces exactly this result.