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?
question about outer joins
Post a Reply
|Oldest Newest Rating|
SQL & Databases
Everything SQL and Databases related in here!
|Bucky Roberts Administrator|