TO JOIN MULTIPLE SELECT STATEMENTS IN BIGQUERY FROM DIFFERENT TABLES

Job ID: 32774354

Budget: $10 – $30 USD

In Bigquery, Keep throwing Errors for Joining Multiple Select Statements. Where is the Error from below statements construct ?

SELECT * FROM (SELECT * FROM 'DATASET_ID_1.RECEIPTS' AS RC
WHERE RC.RECEIPT_AMT>0) AS RECEIPTS

LEFT JOIN

(SELECT * FROM 'DATASET_ID_2.PAYMENTS' AS PY
WHERE PY.PAYMENT_AMT>0) AS PAYMENTS
Related categories: BigQuery