i'm using mySQL as my backend to my program. i know this is not VB.NET
anymore but i don't know how to do it. i have a query that will calculate if
it satisfies the condition. it goes like this:
SELECT
(tblseedsubsidy.NoOfBags)
FROM
agri.tbltrcclient
INNER JOIN agri.tblseedsubsidy
ON (tbltrcclient.ClientID = tblseedsubsidy.ClientID)
INNER JOIN agri.tblinventory
ON (tblseedsubsidy.SeedID = tblinventory.SeedID)
WHERE (tblseedsubsidy.CoOwner = '1'
AND tbltrcclient.TypeofSeed = 'Corn')
HAVING (sum(tblseedsubsidy.NoOfBags) /2);
but every time it doesn't satisfy the condition where CoOwner must be equal
to '1' it returns a null value. how can i convert the null value into 0?
if anyone has any idea on how to do it i would really appreciate it. thanks.
--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/For...b-net/200805/1