SQL programs

Data

Name object id and date made public for models documented with Provenance

Description old version select model.object_id as obj_id, datemodelpublic.object_description as day from objects model, objects datemodelpublic where datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id and model.object_class=19 order by day however now using datemodelpublic.object_name=CAST(models.object_id AS varchar(100))

SQL Program select model.object_id as obj_id, datemodelpublic.object_description as day from objects model, objects datemodelpublic where datemodelpublic.object_class=127 and datemodelpublic.object_name=CAST(model.object_id AS varchar(100)) and model.object_class=19 order by day

Maximum Rows

Maximum Columns