Relationship to the contcommodity table. (contcommodity.contractnum = sfwview.contractnum and contcommodity.revisionnum=sfwview.revisionnum and contcommodity.orgid = sfwview.orgid and contcommodity.commodity in (select commodity from contcommodity where parent is null)
Razmerje do tabele contcommodity. (contcommodity.contractnum = sfwview.contractnum and contcommodity.revisionnum=sfwview.revisionnum and contcommodity.orgid = sfwview.orgid and contcommodity.commodity in (select commodity from contcommodity where parent is null)