Answers for "laravel query left join"

laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

left join laravel

$users = DB::table('users')
            ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();

$users = DB::table('users')
            ->rightJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();

laravel outer join

->join('answers as answers', 'responses.answer_id', '=', 'answers.id', 'left outer')