on 01-11-2018 10:36 PM
(SELECT STRING_AGG(T7."WhsName", ',') FROM RCT2 T5 INNER JOIN OINV T8 ON T5."DocEntry"=T8."DocEntry" INNER JOIN INV1 T9 ON T9."DocEntry" = T8."DocEntry" INNER JOIN OWHS T7 ON T7."WhsCode" = T9."WhsCode" WHERE T5."DocNum" = T4."DocEntry" GROUP BY T5."DocNum", T7."WhsName") AS "Store",
(SELECT STRING_AGG(A1."WhsName", ',')
FROM
(SELECT T7."WhsName"
FROM RCT2 T5
INNER JOIN OINV T8 ON T5."DocEntry"=T8."DocEntry"
INNER JOIN INV1 T9 ON T9."DocEntry" = T8."DocEntry"
INNER JOIN OWHS T7 ON T7."WhsCode" = T9."WhsCode"
WHERE T5."DocNum" =T4."DocEntry"
GROUP BY T7."WhsName")
AS A1) AS "Store"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Query doesnt work!
Where is the reference to T4.DocEntry
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.