aboutsummaryrefslogtreecommitdiffstats
path: root/README.md
diff options
context:
space:
mode:
authorMatthew Lemon <matt@matthewlemon.com>2020-07-28 16:58:40 +0100
committerMatthew Lemon <matt@matthewlemon.com>2020-07-28 16:58:40 +0100
commitcc9f02f678b1fe9f5a5c8c6fda8fafa1bf721b7b (patch)
tree6db5cd2195499676162bfeff4d950690b13a3513 /README.md
parent46741fc3259420f6310ebbfaae2ecd44c64b4373 (diff)
added filename into return_data table
Diffstat (limited to '')
-rw-r--r--README.md5
1 files changed, 5 insertions, 0 deletions
diff --git a/README.md b/README.md
index f0c37ba..a518938 100644
--- a/README.md
+++ b/README.md
@@ -16,3 +16,8 @@ CREATE TABLE return_data(id INTEGER PRIMARY KEY, dml_id INTEGER, value TEXT, FOR
datamap as dm inner join datamap_line as dml on dml.dm_id=dm.id inner join
return on return_data.ret_id=return.id inner join return_data on
return_data.ret_id=return.id;`
+
+### More accurate SQL to test all data at this stage:
+`select datamap.name, datamap_line.key, datamap_line.sheet, return.name,
+return_data.filename, return_data.value from datamap, datamap_line, return,
+return_data where datamap_line.dm_id=datamap.id;`