HI Mike,
Yes, I knew the 30 was there. I replyed with a more detailed explanation of what I was doing to Jim's message. Thanks.
>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?
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!