Don,
Why are you CCing? I already know what I have written:)
Cetin
>Well here's the solution. Thanks Sergey.
>
>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'
>
>select * , ers.name as 'ername', tc1.fullname as 'tc1name', ;
> tc2.fullname as 'tc2name', ceo1.fullname as 'ceo1name' ;
> from trpcontacts!Sites ;
> left outer join (lcERs) ers on sites.er = ers.er_id ;
> left outer join (lcTC1) tc1 on sites.tc1 = tc1.person_id ;
> left outer join (lcTC2) tc2 on sites.tc2 = tc2.person_id ;
> left outer join (lcCEO1) ceo1 on sites.ceo1 = ceo1.person_id ;
> into cursor crsTempBlueBook
>
>
>
>
>>Use table aliases
>>select sites.*, ers.name, tc1.name, tc2.name, ceo1.name ;
>> from (lcSites) sites ;
>> left join (lcERs) ers on sites.er = ers.er_id ;
>> ...
>> left join (lcCEO1) ceo1 on sites.ceo1 = ceo1.person_id
>>
>>
>>>Well I solved this problem using Vladimir's suggestion. Thanks Vladimir.
>>>But now I have a bigger question.
>>>If the main table has fields containing pointers to data in other tables IE sites.er contains an er_id from table er, then
>>>
>>>
>>>lcSites = addbs(fileloc) + 'bluebook\sites'
>>>lcERs = addbs(fileloc) + 'bluebook\ers'
>>>
>>>select * , ers.name ;
>>>from (lcSites) ;
>>>left outer join ers on sites.er = ers.er_id ;
>>>into cursor crsTempBlueBook
>>>
>>>will produce a cursor containing the name of the er taken from the er lookup table. But how do you structure a situation where there are several of these lookups in the main table? As in:
>>>
>>>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) ;
>>> (lcERs) as ers ;
>>> (lcCEO1) as ceo1 ;
>>> left outer join (lcERs) on sites.er = ers.er_id ;
>>> left outer join (lcCEO1) on sites.ceo1 = ceo1.person_id
>>>
>>>etc.
>>>
>>>