FindAllLinked SQL

Bart Pietercil bart.pietercil at gmail.com
Mon May 7 10:41:46 CDT 2007


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

Bart


More information about the Valentina mailing list