I'm attempting to perform the following SQL command concept, but with two sheets in the same google spreadsheet document:
select * from table1 where column1 not in (select column1 from table2)
How do I achieve the same subquery concept using Google Spreasheet SQL?
Here 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.