You are not logged in.
Its ok with the usage of the COALESCE function to replace null value by a user defined string like "+NULL+".
I would like to also notice that be careful with the string type from sqlite because a "empty string" is not null !!
Are they null or empty fields?
this sounds similar to what i am running into:
if you find out the issue, please post back.
I try to do a inner join between all fields from table to another but it doesn't work if any source fields are null !!
Did you have the solution to manage null value ?