How to get fields with the same name but in different tables when executing a join query?

Question

Laravel

There are 2 tables booking_restaurants
: id, id_restaurant, type
restaurant: id, name, type

DB::table('booking_restaurants')
                            ->join('restaurants', 'booking_restaurants.id_restaurant', '=', 'restaurants.id')
                            ->get();

In these tables, the type fields match and as a result I get the value from only one table, how can I get rid of this and get the booking_restaurants type and restaurants type?

Answer 1

In this case, you need to specify the full path to the columns and aliases, by default all columns (*) are selected, which leads to overwriting.

->select(["booking_restaurants.type", "restaurants.type as restaurants_type"])