{"title":"多表查询","inframe":false,"hidden":false,"roles":{"demo":1,"dev":1},"pageLink":"","children":[{"configs":{"itemId":"module"},"children":[{"configs":{"sql":"select\n\na.KEY_ID,a.USER_ID,b.USER_NAME,a.REAL_NAME,a.BIRTHDATE,a.EDU,a.NATION,a.TEL,\na.EMAIL as \"STAFF_EMAIL\",b.EMAIL\n\nfrom WB_STAFF a, WB_USER b where a.USER_ID=b.USER_ID","itemId":"dataprovider1","dictFieldsMap":"{EMAIL: 'WB_USER'}","dictTableNames":"wb_staff,wb_user"},"children":[],"type":"dataprovider","expanded":false}],"type":"module","expanded":true}],"iconCls":""}