Sql Query?

Question

Example: table1    <Users>
Id        Name       MultipleDirectory
1          abc            1001,1003,1004
2          xyz            1002,1004
3          pqr            1003

table2      <Directory>
Id             Directory
1001        asp
1002        vb
1003        asp.net   
1004        javascript

Now My problem is that when i select Directory name- javascript from a gridview, then  2  names-  abc & xyz will  come out. Tell me what's the query i will execute?

thanks