Hello
Please, I need your help.
How can I link or to relate the two queries in a single query?
Of the two queries only have one query
I have two queries and I need to have a query
I have two queries and should have only one query.
Thank for your feedback.
select e.first_name,
e.last_name
from hr.employees e
inner join hr.departments d
on e.department_id = d.department_id
and d.department_name = ‘IT’;
–
select l.city,
l.state_province,
c.country_name
from hr.locations l
left join hr.countries c
on l.country_id = c.country_id
and country_name = ‘United States of America’;