phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Ubale <>
Subject Phoenix Joins
Date Tue, 18 Nov 2014 09:31:03 GMT
HI ,

I am attempting to perform a join on multiple tables in Phoenix. The query I am firing is
select * from "Orders_3" as o
                Inner join "Order_Details_3" as od on od."O_No"=o."O_No"
                Inner Join "Address_3" as a on a."A_C_Id" = o."O_C_Id";
                Inner join "Customers_3" as c on c."C_Id" = o."O_C_Id"
                Inner join "Payterms_1" as p on p."Payt_Id" = o."O_Pay_Items"
where o."O_C_Id"='50001';

However there is no appropriate response from phoenix on this one. I got an error stating
“Error in sub plan(3)”.
The tables contain around 1million rows each. Moreover the size of the tables do not exceed
250 Mb. Why am I not able to get a result for this query or is this a “Work in progress”
area of Phoenix 4.2.
Kindly throw some light on this.

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

we innovate, plan, execute, and transform the business​

View raw message