FindAllLinked SQL

[Ruslan Zasukhin]

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

>> Join now looks MUCH SIMPLER !!!
>> 
>> SELECT *
>> FROM T1 join T2 using blinkName
> 
> Wouldn't this result in a full join ? Can I add a where clause
> 
> SELECT * FROM T1 join T2 using aBinaryLink WHERE T1.recid  = x
> 
> Would this work ?

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]