TO JOIN MULTIPLE SELECT STATEMENTS IN BIGQUERY FROM DIFFERENT TABLES
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
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