SQL Select with Binary Link

[Ruslan Zasukhin]

On 5/20/08 5:34 AM, "Chris McConnell" <chris at mc-data.com> wrote:

Hi Chris,

> I created two databases called customer and custphone.
> 
> I linked them with a binary link "customerphone"
> 
> I added data to both tables with Vstudio.
> 
>  
> 
> Now I need an example of an SQL statement to list all phone numbers for say
> customer number 5.

SELECT Phone.*
FROM phone JOIN customer ON  customerphone
WHERE customer.ID = 5

Also if there is no ambiguity you can do lazy case

SELECT Phone.*
FROM phone, customer
WHERE customer.ID = 5


> I have looked high and low for an example of this and I have not been able
> to find a simple example for a binary link to complete this task.
> 
> I know how to do this with a foreign link but not a binary link.

Here 

<http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:docume
ntation:vsql:reference:reference>

You can see grammar of Valentina SQL.


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