1. Home
  2. Point-Of-Sale Software
  3. Sql to return items in promo

Sql to return items in promo

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

Reply to
Philip Gass
Loading thread data ...

Hi Philip

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

select i.itemlookupcode, i.descripti> Hi,

Reply to
convoluted

did the job - thanks!

Reply to
Philip Gass

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.