Let's say I have two tables Names and PhoneExt

Names Table
Name
Bob
Larry
Sue
Tammy

PhoneExt table:
NAME EXT
Bob 3456
Larry 3458
Tammy 3463


SELECT n.NAME, p.EXT
FROM Name n, PhoneExt p
Where n.NAME = p.NAME

The result would leaves out Sue. How do I write this statement to include
"N/A" for Sue. Not sure if it is COALESCE or ISNULL. Or how to use it if
it was.

Dan

Try

SELECT n.NAME, p.EXT
FROM Name.n
LEFT JOIN PhoneExt p
ON p.NAME=n.NAME

Fred

"DG" wrote in message
...
Let's say I have two tables Names and PhoneExt

Names Table
Name
Bob
Larry
Sue
Tammy

PhoneExt table:
NAME EXT
Bob 3456
Larry 3458
Tammy 3463


SELECT n.NAME, p.EXT
FROM Name n, PhoneExt p
Where n.NAME = p.NAME

The result would leaves out Sue. How do I write this statement to include
"N/A" for Sue. Not sure if it is COALESCE or ISNULL. Or how to use it if
it was.

Dan

Thanks Fred that did the trick

Dan

"Fred" <leavemealone@home wrote in message
...
Try

SELECT n.NAME, p.EXT
FROM Name.n
LEFT JOIN PhoneExt p
ON p.NAME=n.NAME

Fred

"DG" wrote in message
...
Let's say I have two tables Names and PhoneExt

Names Table
Name
Bob
Larry
Sue
Tammy

PhoneExt table:
NAME EXT
Bob 3456
Larry 3458
Tammy 3463


SELECT n.NAME, p.EXT
FROM Name n, PhoneExt p
Where n.NAME = p.NAME

The result would leaves out Sue. How do I write this statement to
include "N/A" for Sue. Not sure if it is COALESCE or ISNULL. Or how to
use it if it was.

Dan