question about outer joins

0 Ray Jung Bahadur · April 22, 2015
Ok Bucky, what do we do when , lets say the same boss wants to change the "NULL" to display as "N/A" ?


for this query 

SELECT customers.name, items.name FROM customers LEFT OUTER JOIN items ON customer.id=seller_id


the output is bunch of data with seller selling blah blah item. But what if it shows Bucky Roberts selling NULL ( my question is I want to replace displaying NULL as 'N/A') what do we do? 

Post a Reply

Replies

Oldest  Newest  Rating
0 mike richardson · April 23, 2015
Try  COALESCE(items.name,'NA') AS Item
  • 1

SQL & Databases

107,113 followers
About

Everything SQL and Databases related in here!

Links
Moderators
Bucky Roberts Administrator