>SELECT A.F1, A.F2, B.F1 ;
>FROM A, B ;
>WHERE B.F2 = "1234" AND A.F1 = B.F1 ;
>INTO CURSOR mytemp
>

Why are you getting a.f1 and b.f1 when they are both the same (depending on Set exact)?

My version of this would be :

Select f1,f2 from a Where f1 in (Select f1 from b where f2 = '1234') ;
into cursor myTemp