writing a single Select Statment -for multi lookup tables-

the project simply is writing one SELECT statement we'll provide a dbase in mysql format, and all what we need is to write a single SELECT statement to choose few records acodring to multi conditions we'll provide. the select statement might be complicated but if you're in a good knowledge with SQL statements, u'll write this in less than one hour task.. BR