From f8bb6d4c574072b53040d1a8c449ba0e9ab2f62d Mon Sep 17 00:00:00 2001 From: Matthew Lemon Date: Tue, 28 Jul 2020 09:13:32 +0100 Subject: updated README with working JOIN SQL statement --- README.md | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'README.md') 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;` -- cgit v1.2.3