Will the SQL 1969 "EXCEPT" compound operator not work for some reason?
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Joseph L. Casale > Sent: Saturday, 27 July, 2013 15:24 > To: 'sqlite-users@sqlite.org' > Subject: [sqlite] Query help > > Hey guys, > I am trying to left join the results of two selects that both look > exactly like this: > > SELECT DISTINCT SUBSTR(col, INSTR(col, 'string')) AS name FROM > table_a > > Both tables have the exact data type and format, I need to reformat > each tables > results, then join and return only what is in table_a and not in > table_b. > > Any guidance on how one might do this in sqlite? > Thanks! > jlc > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users