SELECT CONCAT(C.NAME,B."NAME"),T.HUJI,C.NAME AS WORKSNAME , B.NAME AS STREETNAME, T.ID,T.NAME,T.SEX,T."IDENTITY",T.USERPHONE,T.USERPIC,T.STREET,T.WORKSTATION,T.ADDRESS,T.RELATIONNAME,T.RELATIONSHIP,T.CONTACTSPHONE,T.TELEPHONE,T.IS_LOW,T.IS_GOOD,T.IS_DEEP,T.IS_PLAN,T.LOWPIC,T.GOODPIC,T.DEEPPIC,T.PLANPIC,T."TYPE",T.STATUS,T.ADDTIME,T.FIXPHONE,T.IFDELETE,T.NOSTATUS,T.PERSONID,T.USERPIC2,T."EXPLAIN",T.IDFRONT,T.IDVERSO,T.LONGITUDE,T.LATITUDE,T.UPDATETIME,T.EMPLOYEEID,T.UPDATEEMP,T.APPROVEEMP,T.APPROVETIME,T.HUJI,T.HUKOUPIC,T.OTHERPIC,T.YNCARDID,T.YOUFU,T.RE_APPLY FROM Y_ADVANCEDUSER T LEFT JOIN TBLSTREET B ON B.STREET = T.STREET LEFT JOIN TBLWORKSTATION C ON C.CODE = T.WORKSTATION
时间: 2024-03-31 10:36:29 浏览: 30
这是一条SQL查询语句,它从`Y_ADVANCEDUSER`表中查询了多个字段,并与`TBLSTREET`和`TBLWORKSTATION`表进行了左连接,关联条件分别是`B.STREET = T.STREET`和`C.CODE = T.WORKSTATION`。查询结果包括以下字段:
- `CONCAT(C.NAME,B."NAME")`:将`TBLSTREET`表中的`"NAME"`字段和`TBLWORKSTATION`表中的`NAME`字段拼接后的结果;
- `T.HUJI`:`Y_ADVANCEDUSER`表中的`HUJI`字段;
- `C.NAME AS WORKSNAME`:`TBLWORKSTATION`表中的`NAME`字段,并使用`AS`关键字给该字段取了一个别名`WORKSNAME`;
- `B.NAME AS STREETNAME`:`TBLSTREET`表中的`NAME`字段,并使用`AS`关键字给该字段取了一个别名`STREETNAME`;
- `T.ID`:`Y_ADVANCEDUSER`表中的`ID`字段;
- `T.NAME`:`Y_ADVANCEDUSER`表中的`NAME`字段;
- `T.SEX`:`Y_ADVANCEDUSER`表中的`SEX`字段;
- `T."IDENTITY"`:`Y_ADVANCEDUSER`表中的`IDENTITY`字段;
- `T.USERPHONE`:`Y_ADVANCEDUSER`表中的`USERPHONE`字段;
- `T.USERPIC`:`Y_ADVANCEDUSER`表中的`USERPIC`字段;
- `T.STREET`:`Y_ADVANCEDUSER`表中的`STREET`字段;
- `T.WORKSTATION`:`Y_ADVANCEDUSER`表中的`WORKSTATION`字段;
- `T.ADDRESS`:`Y_ADVANCEDUSER`表中的`ADDRESS`字段;
- `T.RELATIONNAME`:`Y_ADVANCEDUSER`表中的`RELATIONNAME`字段;
- `T.RELATIONSHIP`:`Y_ADVANCEDUSER`表中的`RELATIONSHIP`字段;
- `T.CONTACTSPHONE`:`Y_ADVANCEDUSER`表中的`CONTACTSPHONE`字段;
- `T.TELEPHONE`:`Y_ADVANCEDUSER`表中的`TELEPHONE`字段;
- `T.IS_LOW`:`Y_ADVANCEDUSER`表中的`IS_LOW`字段;
- `T.IS_GOOD`:`Y_ADVANCEDUSER`表中的`IS_GOOD`字段;
- `T.IS_DEEP`:`Y_ADVANCEDUSER`表中的`IS_DEEP`字段;
- `T.IS_PLAN`:`Y_ADVANCEDUSER`表中的`IS_PLAN`字段;
- `T.LOWPIC`:`Y_ADVANCEDUSER`表中的`LOWPIC`字段;
- `T.GOODPIC`:`Y_ADVANCEDUSER`表中的`GOODPIC`字段;
- `T.DEEPPIC`:`Y_ADVANCEDUSER`表中的`DEEPPIC`字段;
- `T.PLANPIC`:`Y_ADVANCEDUSER`表中的`PLANPIC`字段;
- `T."TYPE"`:`Y_ADVANCEDUSER`表中的`TYPE`字段;
- `T.STATUS`:`Y_ADVANCEDUSER`表中的`STATUS`字段;
- `T.ADDTIME`:`Y_ADVANCEDUSER`表中的`ADDTIME`字段;
- `T.FIXPHONE`:`Y_ADVANCEDUSER`表中的`FIXPHONE`字段;
- `T.IFDELETE`:`Y_ADVANCEDUSER`表中的`IFDELETE`字段;
- `T.NOSTATUS`:`Y_ADVANCEDUSER`表中的`NOSTATUS`字段;
- `T.PERSONID`:`Y_ADVANCEDUSER`表中的`PERSONID`字段;
- `T.USERPIC2`:`Y_ADVANCEDUSER`表中的`USERPIC2`字段;
- `T."EXPLAIN"`:`Y_ADVANCEDUSER`表中的`EXPLAIN`字段;
- `T.IDFRONT`:`Y_ADVANCEDUSER`表中的`IDFRONT`字段;
- `T.IDVERSO`:`Y_ADVANCEDUSER`表中的`IDVERSO`字段;
- `T.LONGITUDE`:`Y_ADVANCEDUSER`表中的`LONGITUDE`字段;
- `T.LATITUDE`:`Y_ADVANCEDUSER`表中的`LATITUDE`字段;
- `T.UPDATETIME`:`Y_ADVANCEDUSER`表中的`UPDATETIME`字段;
- `T.EMPLOYEEID`:`Y_ADVANCEDUSER`表中的`EMPLOYEEID`字段;
- `T.UPDATEEMP`:`Y_ADVANCEDUSER`表中的`UPDATEEMP`字段;
- `T.APPROVEEMP`:`Y_ADVANCEDUSER`表中的`APPROVEEMP`字段;
- `T.APPROVETIME`:`Y_ADVANCEDUSER`表中的`APPROVETIME`字段;
- `T.HUKOUPIC`:`Y_ADVANCEDUSER`表中的`HUKOUPIC`字段;
- `T.OTHERPIC`:`Y_ADVANCEDUSER`表中的`OTHERPIC`字段;
- `T.YNCARDID`:`Y_ADVANCEDUSER`表中的`YNCARDID`字段;
- `T.YOUFU`:`Y_ADVANCEDUSER`表中的`YOUFU`字段;
- `T.RE_APPLY`:`Y_ADVANCEDUSER`表中的`RE_APPLY`字段。