>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

You don't specify what field L.O_rec_id is supposed to match against. VFP doesn't assume the same name.

Just a thought.