[Vserve+V4RB] Weird concatenated fields behaviour in searches

[Eric Ferrer]

Ruslan,

Thanks for your answer.

>> Note that Faxes may not have a 'ParentRecipientID', where the recipient is
>> unknown (field is empty).
> 
> More correct to say NULL, right ?
Yes.


>> SELECT Subject, ParentRecipientID, People.AllNames
>> FROM Faxes, People
>> WHERE Faxes.ParentRecipientID *= People.ID
> 
> May be I ma wrong, but it seems you need right outer  =*
> Check just in case.

This "skips" Faxes that have no ParentRecipientID (null value), which is not
good for me.

> If still problems please send me your db + query text
I will prepare this as soon as possible.

Thank you again
Eric