Hi Roi,

>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.

Of course its going to be 30, your select only takes records where ab_id = 30

ON catlink.ab_id = 30

Maybe I misunderstand you. Are you aware this number is there?