The following SQL Select command retrieves the current software version and domain name from the Admin schema tables:
Select rev_software, proj_name from project;
The following SQL Select command retrieves loop numbers and their associated instrument tag numbers from the Domain schema tables:
Select component.cmpnt_name, loop.loop_name from component, loop where component.loop_id = loop.loop_id;
or:
Select c.cmpnt_name, l.loop_name from component c, loop l where c.loop_id = l.loop_id;
-
End each command with a semicolon (;).
-
In this example, the where argument ensures that the tag numbers appear with the correct relationship to the loops to which they belong.