Hi, The query for which I get this :
select * from "Customers_3" as c inner join "Address_3" as a on a."A_C_Id" = c."C_Id" inner join "Orders_3" as o on o."O_C_Id" = c."C_Id" inner join "Order_Details_3" as od on od."O_No" = o."O_No" where c."C_Name" = 'Amit500'; Thanks, Siddharth From: Siddharth Ubale Sent: Tuesday, November 18, 2014 5:28 PM To: [email protected] Subject: Hi HI All, Can anyone explain why we get this error while running joins on many tables in Phoenix : Error: Encountered exception in sub plan [2] execution. (state=,code=0) Thanks, Siddharth Ubale, Synchronized Communications #43, Velankani Tech Park, Block No. II, 3rd Floor, Electronic City Phase I, Bangalore – 560 100 Tel : +91 80 3202 4060 Web: www.syncoms.com<http://www.syncoms.com/> [LogoNEWmohLARGE] London|Bangalore|Orlando we innovate, plan, execute, and transform the business​
