SQL Select with Binary Link

[Bart Pietercil]

Hi William,

if I understand you correctly I think

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


would do the trick. However since you already know that the customer  
you want has ID 5 why would you still need this. You have already  
queried the customer table (since you know this is customer 5) so I  
would suppose you already included in this first query all the fields  
you would want to know about ?

hmmm, confused

hth

Bart Pietercil


On 13 Jun 2008, at 19:22, william humphrey wrote:

> 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
>
> How do you modify the above so a record is returned with customer  
> fields
> even if there is no corresponding phone records?
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina