laravel join
Inner Join : ->join('contacts', 'users.id', '=', 'contacts.user_id') Left Join : ->leftJoin('posts', 'users.id', '=', 'posts.user_id') Right Join : ->rightJoin('posts', 'users.id', '=', 'posts.user_id') Cross Join : ->crossJoin('colors') Advance Queries : ----------------- ->join('contacts', function ($join) { $join->on('users.id', '=', 'contacts.user_id') ->where('contacts.user_id', '>', 5); })