Sql, query
> Hi,
>
> I have a field that I need to do a join on. Unfortunately, the column is
> allowed to be null (and it should be). My plan is to return the literal
> string 'None' if the column is null, and otherwise to return the joined
> value. How can I do this, when the inner join that I want will exclude the
> rows where the column in question is null?
>
> eg:
>
> SELECT
> ... as 'Motion Ref.', title as
> Title,
> IF(IFNULL(o.name,1<0),CONCAT('None'),o.name) as Organization,
> ... as Date FROM m,o
> WHERE (o.ID = m.organization)
>
> Quinten
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
