laravel-json-query-builder icon indicating copy to clipboard operation
laravel-json-query-builder copied to clipboard

how i can make a not exists expression with a subquery

Open catthecreator opened this issue 1 year ago • 0 comments

Hi!

Please tell me how I can create the following expression

select *
from `users`
where `channel_id` = 81
  and (not exists (select *
                     from `user_variables`
                     where `users`.`id` = `user_variables`.`user_id`
                       and `id` in ('489')
                       and `value` = 123
          ))

For one field, I can use the construction !relation.column

But I need not_exists by subquery

Thanks for your attention :)

catthecreator avatar Jan 11 '24 15:01 catthecreator