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
