>lcSites = addbs(fileloc) + 'bluebook\sites'
>lcERs = addbs(fileloc) + 'bluebook\ers'
>lcCEO1 = addbs(fileloc) + 'bluebook\people'
>lcTC1 = addbs(fileloc) + 'bluebook\people'
>lcTC2 = addbs(fileloc) + 'bluebook\people'
>
>** yielding something like
>select * , ers.name, tc1.name, tc2.name, ceo1.name ;
>   from (lcSites) ;
>   left outer join (lcERs) as ers on sites.er = ers.er_id ;
>   left outer join (lcCEO1) as ceo1 on sites.ceo1 = ceo1.person_id
>
>