about displaying data in gridview

Hi,

   I executed a query where I count rows from 2 table. And it gives me the right data in mysql database sql query area. But the same query if i write in my .net form it is not giving me all data in gridview. it shows only 1 row. actually there are multiple records. I don't understand how and why? I used the iner join with group by clause

thanks