Can't execute query

SELECT inf_pharm_n.* 
		    	FROM (inf_pharm_n, inf_pharm)
		    	WHERE inf_pharm_n.name LIKE '%Энтерофурил%' AND inf_pharm_n.code = inf_pharm.code
		    	LIMIT 1

MySQL Error: Table 'vseapteki.inf_pharm' doesn't exist

This script cannot continue, terminating.