Hi,
i have 3 table
1)table employee
emp_id--Name
1-------AA
2-------AB
3-------AC
4-------AD
5-------AE
6-------AF

2)table job_done
emp_id--job_done --score
1--------1-------50
3--------1-------25
5--------1-------70
1--------1-------50
3--------1-------25

3)table job_failed
emp_id -- job_failed
2------------1
4------------1
6------------1
5------------1

Now how can i get result like
Name job_done , job_failed, score
AA---------2----------0----------50
AB---------0----------1----------0
AC---------2----------0----------25
AD---------0----------1----------0
AE---------1----------1----------70
AF---------0----------1----------0



Thanks in advance to get ride on it.