>For a medical system I need to select a group of patients from a master table and load/stuff a table or grid with some of the fields from the master table....easy enough using Select SQL BUT if a field in the master table contains a value which is related to a look-up table, i.e. Region '1' which is actually 'North-East' in the related table, HOW can I transfer 'North-East' into the search results instead of '1'.
>
>At the moment I am doing the Select SQL which transfers raw data from the master table then loading another table with related data etc which takes time
>
>Any ideas please anyone?
You can SELECT firsttable.field,firsttable.field,secondtable.region,,, FROM firsttable JOIN secondtable ON regioncode.
I'm not sure of the exact syntax here after the ON clause.