/PHP/Laravel/Laravel query select from table where id != to another table id

Laravel query select from table where id != to another table id

Laravel query select from table where id != to another table id

DB::table('tbl_sales')
->whereNotIn('id', DB::table('tbl_registration')->pluck('sale_id'))
->get();

1

Similar codes

0 vote196 views2 answers
Laravel belongsto with condition date
PHP Laravel
0 vote231 views1 answer
Laravel collection max
PHP Laravel
9 votes220 views3 answers
Laravel with select
PHP Laravel
0 vote229 views1 answer
Orwhere in wherehas laravel
PHP Laravel
9 votes282 views2 answers
Use resource in laravel 8
PHP Laravel
1 vote240 views4 answers
Current url route laravel
PHP Laravel
0 vote229 views1 answer
Laravel require vendor autoload
PHP Laravel
7 votes246 views6 answers
Remove foreign key constraint laravel
PHP Laravel
11 votes227 views3 answers
How to remove composer package in laravel
PHP Laravel
0 vote261 views3 answers
Embed the site when you click on the link laravel
PHP Laravel

Share