Tip of the week : Use the lookup column to merge data across tables

Tip of the week : Use the lookup column to merge data across tables

While creating reports, sometimes you may need to merge data from separate tables, in order to get the complete picture.  In Analytics Plus, you can use the 'lookup column' and combine data across two related tables in your database. It's that simple, and definitely  easier than writing multiple SQL queries to join tables.  While using the lookup function, just make sure that the parent lookup column has unique, non-repetitive values. 




              New to ADManager Plus?

                New to ADSelfService Plus?