On 12/21/1999 1:16 PM, Bourque, Chad supposedly said:

>I'll take a stab at it before Anders gives you the best answer. <g>

Ain't that always the case? <bg>

>Select A.cInformation As cContainer, B.cInformation As cAdditive ;

> From TableA Left Join TableB A On TableA.iContainerID = A.iID ;

> Left Join TableB B On TableA.iAdditiveIID = B.iID

I would avoid using single letter aliases, as they permit the

possibility of confusion with the old Xbase standard of naming the first

10 (well, then, it was only 10) work areas "A" through "J", as well as

the convention of naming memvar values with an "M" alias. The safest

practice is to use 2 characters as a minimum for alias names.

___/

/

__/

/

____/

Ed Leafe

http://leafe.com/