thienduong584
Member
Dear JDE Technical,
I have a proplem,
In JDE APIs, Can code subqueries SQL?
This sql statement, I want code Business Function C
UPDATE JDE_TABLE_TEST
SET
AADL01 = (SELECT WADOCO FROM F4801 WHERE WADOCO = AAURAB)
WHERE
AAURAB = (SELECT WADOCO FROM f4801 WHERE WADOCO = AAURAB)
AND AADCTO = 'WS'
Thanks!
__________________________________
>> Enterprise Resource Planning
>> JD Edwards® Enterprise One
>> Mail: [email protected]
I have a proplem,
In JDE APIs, Can code subqueries SQL?
This sql statement, I want code Business Function C
UPDATE JDE_TABLE_TEST
SET
AADL01 = (SELECT WADOCO FROM F4801 WHERE WADOCO = AAURAB)
WHERE
AAURAB = (SELECT WADOCO FROM f4801 WHERE WADOCO = AAURAB)
AND AADCTO = 'WS'
Thanks!
__________________________________
>> Enterprise Resource Planning
>> JD Edwards® Enterprise One
>> Mail: [email protected]