Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 74 of 118
Document Version 1.0 Last Updated 10.18.2010
Figure 125Selecting fields from the Employee_Phone table
Next the WHERE clause is utilized to link the emp_id field in this table to the emp_id field
within the Employees table in the Main DataBlock.
Figure 126Linking the Employees table to the Employee_Phone table
After creating the WHERE clause, the SQL for the empl_phone dataset appears as follows:
Figure 127The query for the empl_phone dataset