Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- replacement value for when left join condition is not met.
arms - 10:47 pm on Sep 18, 2011 (gmt 0)
Try:
SELECT IFNULL(customer.name, 'Not Defined')
FROM workorder
LEFT JOIN customer
ON workorder.id = customer.id
Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4363223.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com