When I test the query MySQL Administrator get all ok several records, but when I run the same query in the coda VB net applications get only one record.
why SUM operator in vb net returns only one record?
col2 is a different number and I need to sum up all records with the same col2
query="slect sum (col1) as col1, col2, col3,col4,col5,myt1.scol1 from mytable join myt1 on myt1.id=mytable.idd where myt1.scol1='d1dd1d' group by col2, col3"
MySQL Server 5.1.11
MySQL Data 6.0.4
VB net 2008