diff options
author | Matthew Lemon <matt@matthewlemon.com> | 2020-07-28 16:58:40 +0100 |
---|---|---|
committer | Matthew Lemon <matt@matthewlemon.com> | 2020-07-28 16:58:40 +0100 |
commit | cc9f02f678b1fe9f5a5c8c6fda8fafa1bf721b7b (patch) | |
tree | 6db5cd2195499676162bfeff4d950690b13a3513 /README.md | |
parent | 46741fc3259420f6310ebbfaae2ecd44c64b4373 (diff) |
added filename into return_data table
Diffstat (limited to '')
-rw-r--r-- | README.md | 5 |
1 files changed, 5 insertions, 0 deletions
@@ -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;` |