SQL Select with Binary Link

[william humphrey]

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?