and (UserName like 'tl%' or UserName like 'jd%' or UserName like 'la%' or UserName like 'xs%' or UserName like 'yh%' or UserName like 'qdh%' or UserName like 'fy%') 加上括号试试
select id,UserInforName from PageUser where UserInforName not in(select EName from TourPage where PageTime='3.1-3.8') and UserName like 'tl%' or UserName like 'jd%' or UserName like 'la%' or UserName like 'xs%' or UserName like 'yh%' or UserName like 'qdh%' or UserName like 'fy%'