Correlated subqueries #6697
Description
I want use the follow sql query, but it does work, in MySQL it is ok.
SELECT
(SELECT A1.QTY_SOLD FROM V_LB_DC_ITEM_CUST_MONTH A1 WHERE A1.CUST_ID=A.CUST_ID LIMIT 1) AS TQ_QTY_SOLD,
A.QTY_SOLD
FROM V_LB_DC_ITEM_CUST_MONTH ASee https://materialize.com/blog/?search=Technical+Article how to implement correlated subqueries.
