>

>SELECT D.dr_no,A.po_no,A.desc,D.rate,B.percent ;
>	FROM dr_etc   A ;
>	JOIN po_other C ON A.po_no  =C.po_no ;
>	JOIN delivery D ON A.ctrl_no=D.ctrl_no ;
>	JOIN payetc   B ON ;
>		STR(D.dr_no)+STR(A.po_no)+STR(A.job_no)+A.desc=;
>		STR(B.dr_no)+STR(B.po_no)+STR(B.job_no)+B.desc;
>	WHERE ALLT(C.kind)='FABRIC' AND A.job_no=101571;
>ORDER BY 1,2,3
>

>
>works perfectly under VFP IDE
>but not through SQL PassThrough using ODBC ( from a web page front end )

Endward,

In addition to Sergey's comments, it really shouldn't matter but you might try specifying the LEFT or INNER join keyword. Also, it's probably too late now but "Desc" is a terrible field name (I assume for "description"). Just try to INDEX ON Desc DESC TAG Desc.