/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 vote143 views1 answer
Laravel eloquent hasmany select
PHP Laravel
0 vote155 views2 answers
Laravel pagination layout issue
PHP Laravel
0 vote139 views2 answers
Show number 1 as 00001 laravel
PHP Laravel
6 votes147 views4 answers
Laravel set config
PHP Laravel
3 votes151 views1 answer
Laravel firstOrFail
PHP Laravel
16 votes141 views5 answers
Laravel one command for model table and controller
PHP Laravel
0 vote142 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
2 votes143 views2 answers
Laravel relationship with for single data
PHP Laravel
9 votes158 views4 answers
Laravel group route controller
PHP Laravel
3 votes172 views2 answers
How to get file extension in laravel
PHP Laravel

Share