如何在同一个查询中使用内连接和子句?

i have three tables and want to run INNER JOIN and IN clause on them. can anyone tell me where i am doing wrongi have three tables and want to run INNER JOIN