Hi everybody,

I put the following SQL using Advanced option of the query:

select cast(evl(PEOPLE.LNAME,Entities.Name) as c(40)) as 
lName,PEOPLE.FNAME,PEOPLE.CID,GIFTS.CAMPAIGN,
GIFTS.GIFTREASON,GIFTS.GIFTAMOUNT,Gifts.GiftEvent, 
Gifts.GiftDate,GIFTS.GIFTTYPE,PLEDGES.Ptotal,PLEDGES.Ptotalpay,
PLEDGES.Pbaldue from PEOPLE 
inner join ENTITIES on PEOPLE.MIDNO=ENTITIES.MIDNO 
inner join GIFTS on GIFTS.MIDNO=ENTITIES.MIDNO LEFT 
join PLEDGES on Gifts.GSeqNo = Pledges.gSeqNo order by 8

Now, when I try to run it it gives me an error saying that Order by clause is invalid. I see nothing wrong here, would you please help?

Thanks in advance.