>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?
Hmmm, I don't know, I'm playing with it right now so I'll see.
Thanks
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!