SELECT C.COMPANYNAME,A.USERID,A.LOGINNAME,B.DEPARTMENTID,A.PASSWORDFROM USER ALEFT JOIN DEPARTMENT BON A.DEPARTMENTID = B.DEPARTMENTIDLEFT JOIN COMPANY CON B.COMPANYID = C.COMPANYIDWHERE A.LOGINNAME LIKE 'Tony%'