Tell me which operator to use. There are 2 tables:

table1 table2 clientId clientId 1 2 2 3 3 4

You must create a query to get a column with values ​​that are found in both tables:

 clientId 2 3

PS how to access the table column in BigQuery, if the table name looks like this [big-query-1265: p1_Clickstream.che_magazin_2505_1207], and the column clientId?

  • How to access a table column in BigQuery, if the table name looks like this [big-query-1265: p1_Clickstream.che_magazin_2505_1207], and the clientId column? - Dmitriy

1 answer 1

 SELECT table1.clientId FROM table1 INNER JOIN table2 on table1.clientId = table2.clientId

PS

Название таблицы.Название столбца name of the table. Название таблицы.Название столбца , but you have some strange name of the table - if it is true, give it an alias.

 SELECT t1.clientId FROM [big-query-1265:p1_Clickstream.che_magazin_2505_1207] as t1 INNER JOIN table2 on t1.clientId = table2.clientId
  • How to access a table column in BigQuery, if the table name looks like this [big-query-1265: p1_Clickstream.che_magazin_2505_1207], and the clientId column? - Dmitriy