>Hi Roi,
>
>>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.
>
>Does a LEFT join work?

I'm getting closer

I have this which gives me the opposite, an ab_id for for every catagory, AND an ab_id of .null. for every remaining catlink record * every record in catagory.

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

I also came up with:

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

Which is even closer. I get the correct number of records (47) however ab_id is 30 in each record instead of the 2 were ther is a match.

Still working on it.