on 04-13-2009 8:09 PM
I cretaed UDF in marketing document and linked it to following scripts:
in Godd recipt from PO :
SELECT T0.[U_NTX_ Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[PDN1.ItemCode]
In Good issue:
SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[IGE1.ItemCode]
in Good Transfer:
SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[WTR1.ItemCode]
In Good recipt:
SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[IGN1.ItemCode]
In porchase Orde:
SELECT T0.[U_NTX_Dsc] FROM OITM T0 WHERE T0.[ItemCode] =$[POR1.ItemCode]
I would like to merge this script in one query , how can I do it:??
Edited by: Farhadn on Apr 13, 2009 9:09 PM
Try this one:
SELECT T0.U_NTX_Dsc FROM OITM T0 WHERE T0.ItemCode = $[$38.1.0\]
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Farhadn,
Use UNION between each query.
I hope I understood the intention correctly.
Jesper
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.