大家看看where 条件!
[php]
SELECT a.id "IssueID", a.issuetype "IssueType",
b.status_description "StatusDes", a.dmaic "DMAIC",
b.sort_order "SortedStatusOrder", a.issue "Title",
DECODE(COUNT(c.issue_id),0,'NA','View') "Details",
DECODE(COUNT(d.issue_id),0,'NA','View') "_4Blockers",
DECODE(COUNT(f.issue_id),0,'NA','View') "TrackingSpreadsheet"
FROM scorecard a, topissues_status_codes b, topissues_action c,
topissues_link d, topissues_unit_number f
WHERE UPPER(a.issuetype) IN (9999)
AND a.status_code IN (9999)
AND a.status_code = b.status_code
AND (a.dmaic IN (9999) or a.dmaic IS NULL)
AND UPPER(a.issue) LIKE UPPER('%9999%' )
AND a.id = c.issue_id(+) AND a.id = d.issue_id(+)
AND a.id = f.issue_id(+)
AND f.unit_number BETWEEN '9999' AND '9999'
GROUP BY a.id, a.issuetype,b.status_description,
b.sort_order,a.dmaic, a.issue, a.completion_date
ORDER BY a.issuetype, b.sort_order, a.dmaic
[/php]
--=========================================
[php]
SELECT a.equip_code,b.code_desc, count(a.equip_serial_number) TOTALUNITS,count(d.unit_number) AFFECTED, a.technology_code
FROM ODS_EQUIPMENT a, ODS_LOOKUP b, SCORECARD c,TOPISSUES_UNIT_NUMBER d
WHERE a.technology_code = b.code
AND b.tableid='TechCode'
AND b.code_desc LIKE '%'||replace(c.issuetype, ' Turbine','')||'%'
AND c.id = 9999
AND d.issue_id(+) =9999
AND a.equip_serial_number = d.unit_number(+)
GROUP BY a.equip_code, b.code_desc, a.technology_code
..............
[/php]
|