OrDB
SQL programs
  Data
find number of alternative models
select count(*) from objects alt_mod, eav_memo vers_name, eav_objects alt_vers, eav_int list_num where alt_vers.object_id=45539 and alt_vers.value_=vers_name.object_id(+) and vers_name.attribute_id(+)=312 and alt_vers.attribute_id=314 and alt_mod.object_id=alt_vers.value_ and list_num.object_id(+)=alt_mod.object_id and list_num.attribute_id=310 order by list_num.value_(+)
Other categories referring to find number of alternative models
Revisions: 4
Last Time: 11/6/2006 5:14:46 PM
Reviewer: Tom Morse - MoldelDB admin
Owner: Tom Morse - MoldelDB admin