Lines Matching full:join

36 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
37 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
38 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
39 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status;
70 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
71 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
72 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
73 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status
74 INNER JOIN tko_iteration_result ON
104 INNER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
105 INNER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
106 INNER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
107 INNER JOIN tko_status ON tko_status.status_idx = tko_tests.status;
135 LEFT OUTER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
136 LEFT OUTER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
137 LEFT OUTER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
138 LEFT OUTER JOIN tko_status ON tko_status.status_idx = tko_tests.status;
169 LEFT OUTER JOIN tko_jobs ON tko_jobs.job_idx = tko_tests.job_idx
170 LEFT OUTER JOIN tko_machines ON tko_machines.machine_idx = tko_jobs.machine_idx
171 LEFT OUTER JOIN tko_kernels ON tko_kernels.kernel_idx = tko_tests.kernel_idx
172 LEFT OUTER JOIN tko_status ON tko_status.status_idx = tko_tests.status
173 LEFT OUTER JOIN tko_iteration_result ON
204 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
205 INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
206 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
207 INNER JOIN status ON status.status_idx = tests.status;
238 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
239 INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
240 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
241 INNER JOIN status ON status.status_idx = tests.status
242 INNER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;
270 LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
271 LEFT OUTER JOIN machines ON machines.machine_idx = jobs.machine_idx
272 LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
273 LEFT OUTER JOIN status ON status.status_idx = tests.status;
302 INNER JOIN jobs ON jobs.job_idx = tests.job_idx
303 INNER JOIN machines ON machines.machine_idx = jobs.machine_idx
304 INNER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
305 INNER JOIN status ON status.status_idx = tests.status;
336 LEFT OUTER JOIN jobs ON jobs.job_idx = tests.job_idx
337 LEFT OUTER JOIN machines ON machines.machine_idx = jobs.machine_idx
338 LEFT OUTER JOIN kernels ON kernels.kernel_idx = tests.kernel_idx
339 LEFT OUTER JOIN status ON status.status_idx = tests.status
340 LEFT OUTER JOIN iteration_result ON iteration_result.test_idx = tests.test_idx;