Sql to return items in promo

Mar 09, 2008 2 Replies
P

Hi,



Somone much more inteligent than me once told me a sql to run in HQ which would return all items which have a Qty discount/ promotion applied to them..



I cant find it - would someone be able to remind me?



Thanks v much



Phil


Vote
Twitter Facebook LinkedIn
C

Hi Philip

see if this returns what you are looking for....

select i.itemlookupcode, i.descripti> Hi,

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required