diff options
| -rw-r--r-- | README.md | 5 |
1 files changed, 5 insertions, 0 deletions
@@ -11,3 +11,8 @@ Some useful queries: `CREATE TABLE return(id INTEGER PRIMARY KEY, name TEXT, date_created TEXT); CREATE TABLE return_data(id INTEGER PRIMARY KEY, dml_id INTEGER, value TEXT, FOREIGN KEY (dml_id) REFERENCES datamap_line(id) ON DELETE CASCADE); ` +### This crazy join works +`select dm.name, dml.key, dml.sheet, return.name, return_data.value from +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;` |