Di you try using subquery provided in Phoenix release 4.2 Logic:- a.itemid in (select b.itemid) or a.name in (select b.name)
From: Komal Thombare [mailto:[email protected]] Sent: Monday, November 24, 2014 7:23 PM To: [email protected] Subject: OR condition in Join 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
