SELECT v.*
FROM  (SELECT SYSOBJECTS.NAME AS TABLE_NAME, SYSCOLUMNS.NAME AS COLUMN_NAME, SYSCOLUMNS.COLID AS COLUMN_ID, SYSTYPES.NAME AS DATA_TYPE, SYSCOLUMNS.LENGTH AS DATA_LENGTH,
  SYSCOLUMNS.PREC AS DATA_PRECISION, SYSCOLUMNS.SCALE AS DATA_SCALE, SYSCOLUMNS.ISNULLABLE AS NULLABLE, SYSCOMMENTS.TEXT AS DATA_DEFAULT
  FROM SYSCOLUMNS
  INNER JOIN SYSOBJECTS ON SYSCOLUMNS.ID = SYSOBJECTS.ID AND SYSOBJECTS.XTYPE = 'U'
  INNER JOIN SYSTYPES ON SYSCOLUMNS.XUSERTYPE = SYSTYPES.XUSERTYPE
  LEFT JOIN SYSCOMMENTS ON SYSCOLUMNS.CDEFAULT = SYSCOMMENTS.ID) u
INNER JOIN (SELECT FOBJECTTYPEID, FDEVTYPE, FINHERITPATH, UPPER(FTABLENAME) ftablename, UPPER(FFIELDNAME) ffieldname,
  FBASEOBJECTID fbaseobjectid, T_META_OBJECTTYPE_L.FNAME fobjecttypename
  FROM T_META_OBJECTTYPEREF
  INNER JOIN T_META_OBJECTTYPE ON T_META_OBJECTTYPEREF.FOBJECTTYPEID = T_META_OBJECTTYPE.FID
  LEFT OUTER JOIN T_META_OBJECTTYPE_L ON (T_META_OBJECTTYPEREF.FOBJECTTYPEID = T_META_OBJECTTYPE_L.FID AND FLOCALEID = 2052)
  WHERE ((FREFOBJECTTYPEID = '02b935fd-c670-4041-916f-eb7ab5a5ea15' AND (FTABLENAME <> ' ')) AND (FFIELDNAME <> ' '))) v
ON (u.TABLE_NAME = v.FTABLENAME AND u.COLUMN_NAME = v.FFIELDNAME) where fobjecttypename like '%未签合同职员%'