I might be wrong here, I'm try to learn too, but what I would have expected is
SELECT *;
FROM mytable ;
LEFT JOIN yourtable ON mytable.mydata1 = yourtable.yourdata1 ;
AND yourtable ON mytable.mydata2 = yourtable.yourdata2 ;
AND yourtable ON mytable.mydata3 = yourtable.yourdata3 ;
INTO CURSOR rpt
if I'm wrong, please let me know
Mike
"I can live with doubt and uncertainty and not knowing. I think it is much more interesting to live not knowing than to have answers that might be wrong." - Richard Feynman