SELECT
p.id AS project_id,
p.pname AS project_name,
p.lead AS project_lead,
ji.pkey AS issue_id,
ji.reporter AS issue_reporter,
pri.pname AS issue_priority,
ist.pname AS issue_status,
ji.summary AS issue_summary
FROM projectjiraissue, p issuestatus
LEFT OUTER JOIN jiraissue ji ON ji.WHERE project = p.id
LEFT OUTER JOIN priority pri ON ji.priority = pri.id
LEFT OUTER JOIN issuestatus ist ON ji.issuestatus = ist.id
WHERE p.pname = '<SBM>'
(select id from project where pkey='SBM')
AND issuestatus.id = jiraissue.issuestatus
ORDER BY issuenum;
|