Relationship to the Asset table, used to find the information for the asset which is being referenced by drilldown. (asset.assetnum = drilldown.assetvalue or ((asset.location=drilldown.locvalue and asset.parent is null) or (asset.location=drilldown.locvalue and asset.parent not in (select assetnum from asset b where b.location= drilldown.locvalue and b.assetnum=asset.parent)))). The resulting set will contain one object.
Razmerje do tabele Asset, ki se uporablja za iskanje informacij za sredstvo, na katero se sklicuje drilldown (vrtanje). (asset.assetnum = drilldown.assetvalue or ((asset.location=drilldown.locvalue and asset.parent is null) or (asset.location=drilldown.locvalue and asset.parent not in (select assetnum from asset b where b.location= drilldown.locvalue and b.assetnum=asset.parent)))). Nabor rezultatov bo vseboval en objekt.