updated README with working JOIN SQL statement

1 files changed, 5 insertions, 0 deletions

diff --git a/README.md b/README.md
index 7ee5524..f0c37ba 100644
--- a/README.md
+++ b/README.md
@@ -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;`