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