How to add a Select within a Where

1

I am trying to do a sub query using Dremio. Can you assist with examples.

Example:

where (cname in
(select cname from [DATABASE]
where (group = ‘CC’)
and StartDate between ‘1/1/18 00:00:00’ and ‘3/31/18 00:00:00’ ))
and StartDate between ‘1/1/18 00:00:00’ and ‘3/31/18 00:00:00’ and chkey3 = ‘’ and creportgroup = '’

3

Hi @jabarrjr

Here is an example,

SELECT e.department_id, e.employee_id, e.employee_name
FROM employees e
WHERE e.department_id IN (SELECT d.department_id
FROM departments d
WHERE d.department_id < 30)

Thanks
@balaji.ramaswamy