SQL Subquery containing Joins

Question

I'm using Hive hql. I am trying to inner join two tables filtering on issue_type='Impediments'

Now I have a new requirement to join dm_jira__label to include the label and issue_id columns. I have tried having a subquery adding the issue_id and label by using a left join with dm_jira__label on issue_id

  INNER JOIN datamart_core.dm_jira__release
  ON dm_jira.issue_id =  dm_jira__release.issue_id;
    (   
        SELECT b.issue_id, b.label AS jira_label
        FROM datamart_core.dm_jira__label as B, datamart_core.dm_jira__release AS K
        LEFT JOIN b
        ON b.issue_id=k.issue_id
    );
  WHERE dm_jira.issue_type = 'Impediment') AS J

I am getting the following error:

AnalysisException: Illegal table reference to non-collection type: 'b' Path resolved to type: STRUCT<issue_id:DOUBLE,label:STRING>

See the full code below. thanks in advance.

SELECT DISTINCT
j.project_key AS jira_project_key,
j.issue_type,
j.issue_assignee AS impediment_owner,
j.issue_status AS impediment_status,
j.issue_priority AS impediment_priority,
j.issue_summary AS impediment_summary,
j.`release` AS jira_release,
j.sow AS sow_num,
j.issue_due_date_utc AS jira_issue_due_date_utc,
j.issue_id AS jira_issue_id,
s.sow_family


from (
--Subquery to combine dm_jira and dm_jira__release
  SELECT dm_jira.project_key,
  dm_jira.issue_type,
  dm_jira.issue_assignee,
  dm_jira.issue_status,
  dm_jira.issue_priority,
  dm_jira.issue_summary,
  dm_jira.issue_due_date_utc,
  dm_jira.issue_id,
  dm_jira__release.`release`,
  dm_jira__release.sow

  from datamart_core.dm_jira


  INNER JOIN datamart_core.dm_jira__release
  ON dm_jira.issue_id =  dm_jira__release.issue_id;
    (   
        SELECT b.issue_id, b.label AS jira_label
        FROM datamart_core.dm_jira__label as B, datamart_core.dm_jira__release AS K
        LEFT JOIN b
        ON b.issue_id=k.issue_id
    );
  WHERE dm_jira.issue_type = 'Impediment') AS J


INNER JOIN datamart_core.dm_asoe_jira_scrum_summary AS S
ON j.`release` = s.jira_release
AND j.sow = s.sow_num
AND j.project_key = s.jira_project_key;