ws.itInLstCaTo.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of beige-acc Show documentation

It consists of double entry accounting and trading (web-store) business logic. It's based on previous beigesoft-accounting and beigesoft-webstore projects.

The newest version!

select IID, ITID, PRI
from (
  select IID, ITID, PRI
  from ITLIST
  where QUAN>0 and TYP=:ITTYP :WHEREADD
 ) as ITALL
join (
  select distinct ITM as ITINCAT from :TITCAT where CATL:FLTCAT
 ) as ITINCATALL on ITINCATALL.ITINCAT=ITALL.ITID