| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to handle second table with no values.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide the Table Handle? | Excel Discussion (Misc queries) | |||
| handle error in cell values | Excel Programming | |||
| How can I handle negative time values? | Excel Worksheet Functions | |||
| Handle missing values | Charts and Charting in Excel | |||
| Handle missing values | Excel Programming | |||
Threaded Mode
