About query problem

Question

Hi

my problem is about query. I have 3 tables : Models,Languages and ModelsLanuages.

in search form user clicks languages and the result should be with the way user want. What i cant do is when user picks English and German, the result should be models who knows English and German. If model knows German but doesnt know English, it shouldnt be on the result.But in my case, it comes to the result.This is where i have trouble

md.LanguagesID=1 and md.LanguagesID=3 it is not working...

select * from Models m join ModelsLanguage md on md.ModelID=m.ModelID join Languages d on d.LanguagesID=md.LanguagesID where (m.Yasi between 0 and 99 ) and (m.AyakkabiNo between 0 and 50 ) and md.LanguagesID=1 and md.LanguagesID=3

Thanks...