<< Click to Display Table of Contents >> Navigation:  IMS version 21.9 > IMS Admin - User Guide  > 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#