SQL programs

Data

Name model serial no, obj id, name, and made public date

Description

SQL Program select serialno.value_, model.object_id,model.object_name, datemodelpublic.object_description from objects datemodelpublic, eav_int serialno, objects model where datemodelpublic.object_id=serialno.object_id and datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id order by value_

Maximum Rows

Maximum Columns