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-02' and grnno not in (Select sale_id from saletrans_cons where paymode='Credit') group by supplier_code but when I use VB to send this same query the results exclude the last record. Can anyone tell me why I'm having this issue with VB? Thanks. Veln
