All pastes #429968 Raw Edit

Stuff

public sql v1 · immutable
·published 2007-04-08 16:55 UTC
rendered paste body
SELECT     processes_1.uut_level3 AS Issue, Tests_1.Test_Name AS Number, processes_1.UUT_Name AS name,                          (SELECT     results.Pass_Flag                            FROM          results INNER JOIN                                                   sequencer ON results.sqid = sequencer.sqid INNER JOIN                                                   Tests ON sequencer.tid = Tests.tid INNER JOIN                                                   sub_processes ON Tests.spid = sub_processes.spid INNER JOIN                                                   processes ON sub_processes.pid = processes.pid ) AS H3FROM         processes AS processes_1 INNER JOIN                      sub_processes AS sub_processes_1 ON processes_1.pid = sub_processes_1.pid INNER JOIN                      Tests AS Tests_1 ON sub_processes_1.spid = Tests_1.spid INNER JOIN                      sequencer AS sequencer_1 ON Tests_1.tid = sequencer_1.tid INNER JOIN                      results AS results_1 ON sequencer_1.sqid = results_1.sqidWHERE     (NOT (Tests_1.Test_Name LIKE N'Skip%'))ORDER BY Issue