I am a newbie so please do not be so harsh. I am a pretty good at SQL but I want to get better. What type of query is this? (I know it contains a subquery because of the left join). Thanks in advance. select site.site_name, company_m.company_name, hrs.employee_hrs from OSHA_SITE_MASTER site inner join OSHA_COMPANY_MASTER company_m on site.company_id = company_m.company_id left join ( select employee_hrs, statmaster.site_id, begin_date_range from OSHA_STATISTICS_MASTER statmaster inner join OSHA_STATISTICS_DETAIL stat_detail on stat_detail.statistic_master_id = statmaster.statistic_master_id inner join osha_date_ranges as osha_date on osha_date.date_range_id = statmaster.date_range_id where osha_date.begin_date_range = '1/1/2007' ) as hrs on hrs.site_id = site.site_id where company_m.company_id = 11
Thanks Guys. I needed to know so if i am looking for help on queries like this, I will know how to search for them.