FindAllLinked SQL

[Bart Pietercil]

OK, I have join....on..... working

BUT


can I do something like this

SELECT T1.* FROM T1 join T2 on binarylinkname WHERE T2(!!!!) recid = x

or this

SELECT T2.* FROM T1 join T2 on binarylinkname WHERE T1.recid


I tried this

SELECT competence_cards.recid,competence_cards.* FROM  
competence_cluster join competence_cards on mm_compcards_to_cluster  
WHERE competence_cluster.recid = 1

So I want all competence cards that are linked on cluster with recid = 1


VStudio does not complain but gives all the records back (as if there  
was no where clause)


When I look in the grammar

join_specification
     :	ON ( link_name | search_condition )

it looks like link name and search condition are mutual exclusive ?

Please advice

BArt



>
> Of course
>
> SELECT *
> FROM T1 join T2 using aBinaryLink
> WHERE T1.recid  = x
>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina