var data = (from s in db.books
join t in db.teachers on s.Auther equals t.Code
where t.Name == "s1mple"
select s).ToList();