FindAllLinked SQL

[Ruslan Zasukhin]

On 7/5/07 6:41 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>> SELECT *
>> FROM T1 join T2 using aBinaryLink
>> WHERE T1.recid  = x
>> 
> 
> This works ok on binarylinks which are One to Many
> 
> It does not seem to work on binarylinks that are many to many
> 
> 
> The problem is not in the binary link. I verified in the databrowser
> in VStudio that competence_clusters point to only some
> competence_cards (certainly not all)
> 
> However running a select query as stated above returns all records in
> the table

Can you send to me and Ivan a test db + query.

Tell us what you get,
And what you EXPECT to get.
Ok?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]