Steve,

>Here's my SELECT command example that doesn't do what I want.

You're not going to be happy until you further normalize your tables. For a lookup table that contains several different types of lookup values, you need essentially three fields (four if you assign a meaningless primary key to each record):

LookType   C   3    LOC, TRN, WHO, EMS, AED, etc. (each set 
                    of records with like values here constitutes
                    one "virtual lookup table"). For example, all 
                    the TRN records are your trainedby lookups
LookCode   C   2    contains the lookup code
LookDesc   C   25   description

Put an index on LookType+LookCode to give you a way to join to each virtual table.

Or, you could separate each type of lookup into individual tables named LookLoc, LookTrn, LookWho, etc and just use LookCode and LookDesc fields with a lookup on LookCode. This second approach would make what you are attempting with the select much easier to accomplish, using OUTER JOINS from the aed.info fields to the LookCode in each table (assuming that you want all records from aed.info with the descriptions from the lookups matching up to the various fields) ... unless I'm totally misunderstanding what you want.