Brent, please don't ask the same question in two different threads. You already asked this in "Outer join question". Be patient! You'll get responses.

>I have this SQL statement that says my where clause is invalid. Anyone know why??
>
>
>SELECT * FROM conflist L RIGHT OUTER JOIN conford O ON L.O_rec_id INTO CURSOR tempord ;
> WHERE !empty(L.O_rec_id)
>
>Thanks