Is there a way to use joint query from Google Sheet?
Can you elaborate on your use case? Do you want to merge data from multiple Google Sheet queries into one Table widget?
Okay, There are Three Tables (Sheets)
Sheet A → Customer (Customer Details)
Sheet B – > Invoice Main (Main Invoice Numbers)
Sheet C → Invoice Items (List of Items in any Invoice Referenced by Main Invoice Number)
SELECT * From “Sheet A” & “Sheet C” WHERE “Customer_ID Sheet A” EQUAL “Customer_ID Sheet B” & “Invoice_ID Sheet C” EQUAL “Invoice_ID Sheet B”
Basically assembling the invoice.
Unfortunately, it doesn’t work this way. But you can achieve it using JS Object to merge the data. Please fork the sample app from this other forum post to check its code.