MySQL Forums
Forum List  »  Newbie

NULL values in my result set
Posted by: Exie Smith
Date: September 24, 2012 10:27AM

I need help diagnosing this query or a better way of running it. I recently added some new fields to my database but I get NULL values returned in my result set. I sm not sure why since when I look at the table that holds the new values they are there.

Here is the query:
use kayako_fusion;
select * from swtickets t
left join swcustomfieldvalues cfv
on t.ticketid = cfv.typeid
left join swcustomfieldoptions cfo
on cfv.fieldvalue = cfo.customfieldoptionid
where t.resolutiondateline > '1346457600';

I can confirm my values are in the swcustomfieldoptions table and again in my result set, I see the customfieldoptionid value but the field I am looking to see populate is called optionvalue which is a part of the swcustomfieldoptions table but for some reason returns with NULL values in the query above.

Any help and direction is greatly appreciated.

Options: ReplyQuote

Written By
NULL values in my result set
September 24, 2012 10:27AM
September 24, 2012 10:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.