How to write this query using Laravel 5 Query Builder?

Question

I want to write this Sql query using in Laravel 5 Query Builder.

SELECT  * FROM Call WHERE phone_number NOT IN (SELECT phone_number FROM Phone_book)

or(Alternative way)

SELECT * FROM   Call
         LEFT OUTER JOIN Phone_Book
          ON (Call.phone_number = Phone_book.phone_number)

or(Alternative way)

   SELECT * FROM   Call
        WHERE  NOT EXISTS
          (SELECT * FROM   Phone_book
             WHERE  Phone_book.phone_number = Call.phone_number)
               WHERE Phone_book.phone_number IS NULL

I tried several ways but i couldn't write a query.is there any way to use Sql syntax with in query builder or how write this same query using Query Builder? please , help me.

(I tested above 3 query out put is same . I want to write these one query using Query Builder syntax)

Which query (not "quarry") do you actually want to build using Laravel? Have you tested any of these queries? — Tim Biegeleisen
– Tim Biegeleisen, Commented Sep 17, 2015 at 0:55
@aldrin27 I attempted [laravel.com/docs/5.0/queries#joins] .but i couldn't take expected results. :-( — uma
– uma, Commented Sep 17, 2015 at 1:09

Kuang · Accepted Answer · 2015-09-17 06:41:34Z

2

DB::table('Call')->whereNotIn('phone_number', function($query)
{
    $query->select('phone_number')
        ->from('Phone_book');
})
->get();

This code is absolutely same with the first sql query u posted.

edited Sep 17, 2015 at 6:41

answered Sep 17, 2015 at 3:15

Kuang

253 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to write this query using Laravel 5 Query Builder?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related