Hi,
use coalesce(p1.name, 'empty') to substitute a text 'empty' for a null
column.
Martin
Roger schrieb:
Please help me, i am running out of time.
I am building a web based application which runs with on sqlite as the
database.I am now creating my reports using Agata.
My problem is as follows.
I am trying to create a view so that my report tool queries directly
from the view as follows
Select p.name||p1.name||p2.name
from people as p left join user as u as
u.uid = p.pid left joun people as p2 on
u.uid=p2.pid left join people as p3 on
u.uid=p3.pid;
The problem is that if one of the rows does not have a value, it returns
and empty string.Now in my report i end up with lots of null columns.
Please help, how do i return something at least from this query if one
of the columns has a null value in it.
Regards
Roger
