>>

>>SET @lcsqlcmd = '
>>	select #treport.*, apvadr.cphone as cBphone, apvadr.ccontact as cBcontact,
>>		apvadr.ccompany as cBcompany, apvadr.caddr1 as cBaddr1, apvadr.caddr2 as cBaddr2,
>>		apvadr.ccity as cBcity, apvadr.cstate as cBstate, apvadr.czip as cBzip,
>>		apvadr.ccountry as cBcountry
>>	from #treport JOIN apvadr ON #treport.cvendno = apvadr.cvendno
>>	where apvadr.cvendno = ''Z_SKIPS'' and apvadr.ctype=''O'' and apvadr.caddrno = ''MIA''
>>	order by 79
>>	,' + @lcsortno
>>

>>
>>>The relation between them should be a field name cvendno, both tables have it
>>>
>>>>What's releationship between #treport an apvadr ?
>
>
>thanks,I am polishing it now

I found the message I was thinking of

Re: Passing order by string Thread #781874 Message #781878 See if you can get to the article.