I'm attempting to perform the following SQL command concept, but with two sheets in the same google spreadsheet document:select * from table1where column1 not in (select column1 from table2)How do I achieve the same subquery concept using Google Spreasheet SQL?UpdateHere is a conceptual example of what I'd like to accomplish: I have a list of requirements on one sheet, and a requirement accomplishment log on another sheet. The log is simply the person's name and the name of the requirement (matching the other sheet). I'd like to see a report on all the requirements that do not exist in the requirement accomplishment log.
Google Spreadsheet SQL subquery where not in
google spreadsheets
Maybe something like this and with filtering to select Not accomplished:   The formula in C2 (copied down) is:  =if(not(iserror(vlookup(B2,Sheet2!B:B,1,0))),,Not accomplished)