Can somebody help me please. I am doing something wrong and I cannot put my finger on it.

I have a cursor called crsfinal which list a number of records. There is just 1 field in here called mainkey.

I would then like to query another table which has the same key in it which is called modacad. There fore my syntax is:

SELECT * FROM modacad ;
WHERE modacad.mainkey=crsfinal.mainkey
INTO CURSOR crsmatch

When I look at crsmatch it finds only 1 record. I would expect it to show me all records that match those records in crsfinal.