Laravel Ask WHERE NOT IN

Question

Laravel Ask WHERE NOT IN

Navigation

#1 by (0 votes)

0

I have the following SQL query

SELECT * from autor where autor.Id_autor not in 
       (select ca.fk_autor from cntrl_autor ca 
        join autor a on a.Id_autor = ca.fk_autor 
        where ca.fk_doc=7993)

How can I convert it to how the Laravel query builder handles it?

laravel laravel-5

asked by Ccin 30.03.2018 в 00:14

source

1 answer

how to save a square image when the original image is rectangular? Add content to the Orders grid in order view of magento 2.2.2

score 0 · Answer 1

You can use DB :: RAW and pass your query or you can use the following

DB::table('autor')
  ->whereNotIn('Id_autor', DB::table('cntrl_autor')
  ->join('autor', 'cntrl_autor.fk_autor', '=', 'autor.Id_autor')
  ->where('cntrl_autor.fk_doc', 7993)
  ->pluck('autor.Id_autor')->values());