Toad World® Forums

I have two queries and should have only one query


#1

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’;


#2

Your ask has nothing with this forum. please ask that on SQL dedicated forums dependent on db you are using (assume that according join is SQL server)