Hi Dorin

At 04:50 pm 13/01/2004, you wrote:

>Hi!
>Try:
>SELECT MSALESREPS_A.*,
> MSALESREPS_B.CNAME AS CSPONNAME,
> MSALESREPS_B.CCITY AS CSPONCITY,
> MSALESREPS_B.CCODE AS CSPONCODE
> FROM MSALESREPS MSALESREPS_A
> LEFT OUTER JOIN MSALESREPS MSALESREPS_B
> ON MSALESREPS_A.IPID = MSALESREPS_B.IID
> ORDER BY MSALESREPS_A.CNAME, MSALESREPS_B.CCITY

Yes that did it, the alias seemed to be the problem. Thanks a lot.




Regards
Bhavbhuti

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/01/2004


[Non-text portions of this message have been removed]