FindAllLinked SQL

[Ruslan Zasukhin]

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

>> 
>> SELECT *
>> FROM T1 join T2 using blinkName
> 
> In VSTudio I try this
> 
> 
> SELECT * FROM competence_cluster join competence_cards using
> (mm_compcards_to_cluster)
> 
> results in error
> 15:53:34: Error: line 1:1: expecting '(', found
> 'mm_compcards_to_cluster'
> 15:53:51: Error: Identifier "mm_compcards_to_cluster" is not found.
> 15:53:51: Error: Kernel error: 0x51500
> 15:53:51: Error: Identifier "mm_compcards_to_cluster" is not found.
> 
> 
> The binary link name was copied from VStudio
> I added the () per the error reported in VStudio
> Broken ?
> 
> Please advice

I have check GRAMMAR page:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:sqlgrammar#queries

And see here 

join_specification
    :    ON ( link_name | search_condition )
    |    USING ( column_name_list )

OPS,

It needs use ON but not USING

SELECT * 
FROM 
   competence_cluster JOIN competence_cards ON mm_compcards_to_cluster



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