data_pump/readers/sql.md

@@ -29,16 +29,17 @@ $CONDITIONS 可被认为是一个条件表达式， 且它应该与SQL其它条
 
 tb_team
 
-|id|name|
-|----|----|
-|1|marvel|
+|  id  |name  |
+| ---- |----  | 
+| 1    |marvel| 
+| 1    |marvel| 
 
 tb_members
 
 |id|team_id|member_name|
 |----|----|----|
-|1|1|Iron Man|
-|2|1|Spider Man|
+|1  |1  |Iron Man|
+|2  |1  |Spider Man|
 
 
 打包后的数据为：
@@ -78,6 +79,58 @@ tb_members
           - member_name
 ```
 
+
+
+tb_team
+
+|  id  |name  | sex |
+| ---- |----  | --- |
+| 1    |marvel| Man |
+| 1    |marvel| Woman |
+
+tb_members
+
+|id|team_id|member_name|  sex |
+|----|----|----|----|
+|1  |1  |Iron Man| Man |
+|2  |1  |Spider Man| Man |
+|3  |1  |Black widow| Woman |
+
+
+打包后的数据为：
+```json
+{
+    "id": 1,
+    "name": "marvel",
+    "sex": "Woman",
+    "members": [
+        {
+            "id": 3,
+            "team_id": 1,
+            "member_name": "Black widow",
+            "sex": "Woman"
+        }
+    ]
+}
+```
+
+所需的配置如下：
+```yaml
+    table: "select * from tb_team where $CONDITIONS id='1' and sex='Woman';"
+    pack:
+      - name: "members"
+        table: "tb_members"
+        join_on:
+          left: "id, sex"
+          right: "team_id, sex"
+        columns:
+          - id
+          - team_id
+          - member_name
+          - sex
+```
+
+
 |配置参数|说明|
 |----|----|
 |name|打包后数据的字段名|