I have 2 tables
This first table, CatLink, has 2 fields
ab_id and catagory

CatLink may have nay number records where the value in ab_id is identical.

The second table, Catagory has 1 field, Catagory. There are 47 total records with each record containing a unique value.

I think you call it a many-to-1 relationship?

I need to end up with a cursor which has 1 record for every record in Catagory (47) and the value of ab_id if ab_id is in the CatLink table (and matches the where clause)
.
I tried:

SELECT catlink.ab_id, catagory.catagory ;
	FROM catagory ;
	right JOIN  catagory ;
	ON catlink.catagory = catagory.catagory ;
	where catlink.ab_id = 57 ;
	INTO CURSOR temp

This gives me the correct number of records however every record is the same. I tried it a bunch of different ways and am now completely confused.

Any help would be appreciated.