Hi, Does anyone know any way or workaround to apply OR condition in Join.
for example: select * from a join b on a.itemid=b.itemid OR a.name=b.name; This is not supported in Phoenix and there also no Union operator support yet. Thanks and Regards, Komal Ravindra Thombare =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
