I am doing an outer join where I want to pull in all record from conford and just O_rec_id from conflist. Here is my statement.
select * from conflist L right outer join conford O on L.O_rec_id into cursor tempord
When I run this I get an error that says my where clause isn't right. I want all the records so I don't need a where clause right?
Do I have to add an inner join or something? What should I put in the where clause?
Thanks
Brent Knight
Progressive Impressions International
Bloomington, IL
Wise men talk because they have something to say; fools, because they have to say something.
-Plato