>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
Assuming O_Rec_ID is the foreign key from ConfList [L], you need a join condition:
JOIN CONFORD O on L.O_Rec_ID = O.Rec_ID
Mark McCasland
Midlothian, TX USA