BigQuery中出现意外的输入结束错误

Question

尝试在BigQuery中进行简单联接。我已经好几年没用过了(生疏(，所以可能只是我语法中的一个小错误。它是标准SQL。

SELECT 
fiscal_week_of_year,
sum(quantity) as units_ordered,
round(sum(item_price),2) as total_item_price,
FROM `order_table` 
where brand = "XYZ" 
and currency = 'USD' 
and sales_channel = 'FakeChannel.com'
and date(purchased_at_PST) between '2021-01-03' and '2021-01-09'
join 
on  date(order_table.purchased_at_PST) = date_table.date_formatted
; 

我得到的错误是：语法错误：预期输入结束，但在[15:]处得到关键字JOIN

purchased_at_PST是DATETIME，date_formated是date字段

Answer 1

尝试提及要加入的表的名称。