Learn Bigquery
Introduction
Architecture
Architecture Compute Storage
Unique Features
Encryption Column Level Security Time Travel Caching Compression
Database Management
Create Table Create View Create Procedure
Best Practices
Avoid Select * Use Web UI Execution plans
Interview Questions
Top Questions Optimization questions DBA questions Migration questions
Home » Bigquery
      Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread



Post Comment

charles08-Dec-21

Error message on my code, please help. Appears on the last line. Unrecognized name: Orders at [8:58]

SELECT

Orders.*,

warehouse_alias,

warehouse.state

FROM

`my-project-112781125.Warehouse_Orders.Orders`

JOIN

`my-project-112781125.Warehouse_Orders.warehouse` ON Orders.warehouse_id = warehouse.warehouse_id 

I could not make it work. Thanks.  

0ReplyMore..ReportDelete
mCollins09-Dec-21

The table alias seems to be missing. eg. `my-project-112781125.Warehouse_Orders.Orders` Orders

0ReplyMore..ReportDelete