Lines Matching full:join
31 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
32 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
33 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
34 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status;
65 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
66 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
67 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
68 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status
69 INNER JOIN tko_iteration_result ON
99 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
100 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
101 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
102 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status;
130 LEFT OUTER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
131 LEFT OUTER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
132 LEFT OUTER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
133 LEFT OUTER JOIN tko_status ON tko_status.status_idx = tko_tests.status;
164 LEFT OUTER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
165 LEFT OUTER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
166 LEFT OUTER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
167 LEFT OUTER JOIN tko_status ON tko_status.status_idx = tko_tests.status
168 LEFT OUTER JOIN tko_iteration_result ON
199 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
200 INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
201 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
202 INNER JOIN status ON status.status_idx = tests.status;
233 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
234 INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
235 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
236 INNER JOIN status ON status.status_idx = tests.status
237 INNER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;
265 LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
266 LEFT OUTER JOIN machines ON machines.machine_idx = jobs.machine_idx
267 LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
268 LEFT OUTER JOIN status ON status.status_idx = tests.status;
297 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
298 INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
299 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
300 INNER JOIN status ON status.status_idx = tests.status;
331 LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
332 LEFT OUTER JOIN machines ON machines.machine_idx = jobs.machine_idx
333 LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
334 LEFT OUTER JOIN status ON status.status_idx = tests.status
335 LEFT OUTER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;
