This document shows you how an IDD Code Table can be made to behave like an SQL Table to, for example, convert State Codes in an SQL Data Table to State Names (from the IDD Code Table).This should complement the training provided from the session IUAP4 - Session Review - SQL and Web Connectivity for IDMS - Cal Domingue(CA) - Tue, Dec 2nd 2014 at the IUA/CA Technical Workshop today. I hope that you enjoy learning how to perform this "sleight of hand" using SQL, by following the step-by-step instructions!
Cheers - Gary