>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao