Re: Query bug

2011-07-24 Thread Velen Vydelingum
ot;) Veln - Original Message - From: "Johnny Withers" To: "Velen Vydelingum" Cc: Sent: Sunday, July 24, 2011 17:41 Subject: Re: Query bug What's your vb code for outputting the results look like? On Jul 24, 2011 8:22 AM, "Velen Vydelingum"

Re: Query bug

2011-07-24 Thread Johnny Withers
What's your vb code for outputting the results look like? On Jul 24, 2011 8:22 AM, "Velen Vydelingum" wrote: Hi, I have the following query which is fine when I run it from the mysql shell screen: select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where paymentdate<='2010-12-0