SELECT * FROM s_fieldassodetail WHERE fieldasso=1564381047325600343;
SELECT * FROM s_archive_field WHERE tableid="f1_2_document";
按照 s_archive_field 表为主查询字段 code 和 s_fieldassodetail 表字段 targetfield 连接进行查询
SELECT saf.`code`,saf.`name`,saf.tableid,sf.sourcefield,sf.sourcefieldname,sf.sourcetableid,sf.fieldasso
FROM (SELECT * FROM s_archive_field WHERE tableid="f1_2_document") AS saf
LEFT JOIN (SELECT * FROM s_fieldassodetail WHERE fieldasso=1564381047325600343) AS sf
ON saf.code=sf.targetfield;