Problem SQL Query

Question

hi,

 I have some problem in sql query. I have 2 table with data like--

Table1

id  Project_id       Emp_id  Task_Name  status
282  70  ,42,43,44,  abcd  1

244  60  ,42,34,  xyz  2


Table2

id  Emp_id  Project_id  module

1  42  ,70,60,  ,282,244,
 
2  43     ,60,70     ,282,


This is my two table  but i want a  Query which will show me the record  id ,project_id, Task_Name  status
 one condition is there. if Table1  id and Project_id is present in the Table2  then status 1 will show ON . if  id  and Project_id not present then status2 will show OFF  in Table2