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

[geraldss]

Mukesh,

Try the following:

@mukeshraghu1c

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