Demaestro - 4:24 pm on Jun 16, 2011 (gmt 0)

The Pseudo code for doing this at the application level is:

job_data = select * from jobs where idCustomer = 1

foreach (job in job_data) {
employee_data = select * from employee where idEmployee = job['job_op'] OR idEmployee = job['tech1'] OR idEmployee = job['tech2']

return_data = job + employee_data
}