<< Click to Display Table of Contents >> Navigation:  IMS version 22.6 & 22.9 > IMS Admin - User Guide 22.6 & 22.9 > Extra Fields  > Extra Fields Tab  > ValueFromSql

 

Example

SELECT NVL ( (SELECT efv.value FROM EXTRAFIELDVALUES EFV

WHERE efv.extrafieldid = 521 AND efv.objectid = circuits.circuitid), 0)

- NVL ( (SELECT sum(efv.value)  FROM EXTRAFIELDVALUES EFV

WHERE efv.extrafieldid in 561,562,563,564,565) AND efv.objectid = circuits.circuitid), 0) speed

FROM CIRCUITS

WHERE #REPLACE#