Jon Barker
Reputation: 54
Bigquery need to check for the existence of a set of values in one column in one set of tables and not in the other set of tables
Three table has a column with, for example, names. Need to know which names do not exist in the other three tables. Need to do this as efficiently as possible.
Upvotes: 1
Views: 590
Answers (1)
Mosha Pasumansky
Reputation: 14004
select name from table1, table2, table3
where name not in (select name from other1, other2, other3)
Upvotes: 1
Related Questions
- How to check if a combo of two fields in one table appears in another table?
- How can I compare multiple tables in Bigquery and get the results in in separate columns?
- Query records in one table that exists in either of two columns in another table
- scan if value of one table are in other ones without joining
- Bigquery: Compare the columns in two tables to see if they match
- Is there anyway to check if one field exists in different tables?
- How to see if a string in a table contains strings specified in a different table
- SQL: At least one value exists in another table
- Checking if a set of values exists in multiple tables
- query multiple tables that use the same fields