Is it possible put Joins on multiple document types in Same bucket

mukeshraghu1c · November 27, 2015, 5:38am

Thanks Geraldss

It works for me using below query-

SELECT * FROM test INVOICE JOIN test CUSTOMER ON KEYS “CUSTOMER_” || TOSTRING(INVOICE.CUSTOMER_ID) WHERE INVOICE.DOCUMENT_TYPE = “INVOICE” AND CUSTOMER.DOCUMENT_TYPE = “CUSTOMER”;