Hi!

I create two tables:

CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY,
    "C"."CustomerName" VARCHAR,
    "C"."Country" VARCHAR
)

and

CREATE TABLE "Orders2" ("OrderID" VARCHAR NOT NULL PRIMARY KEY,
    "O"."CustomerID" VARCHAR,
    "O"."Date" VARCHAR,
    "O"."ItemID" VARCHAR,
    "O"."Quantity" VARCHAR
)

When i have a join, i recived this msg:

"Error: Encountered exception in sub plan [0] execution.
SQLState:  null
ErrorCode: 0"

My phoenix version is 4.5.0

Thanks!