记录一下；多表查询数据-SQL

一表OK：
SELECT DLLClName ,DLLMenuName FROM  table2  WHERE company_name ='A' and employee_age<30;

二表OK:
 SELECT A.UserName, A.SysMenu, A.MenuItem ,  B.DLLClName ,b.DLLMenuName ,b.DLLName ,b.SVGFile , B.Version
FROM ( UserTypeTable  A
JOIN MenuInfoTable B  
ON  A.SysMenu =B.DLLMenuName and B.IsUser ='true' and A.UserName ='项目助理') 

三表查询OK
SELECT B.UserName,a.IsUser , B.SysMenu, B.MenuItem ,  A.DLLName ,A.SVGFile , A.Version  ,C.FileName ,C.FTPPath ,C.MD5 FROM ( UserTypeTable b LEFT JOIN  MenuInfoTable a  ON  B.SysMenu =A.DLLMenuName and b.MenuItem =a.DLLClName  ) LEFT JOIN  DLLInfoTable c ON  a.Version = c.Version where B.UserName ='外协工程师'and A.IsUser ='true'