How to create view into datagridview with 2 tables in VB.NET?

ERROR [57014] ERROR: canceling statement due to statement timeout;
Error while executing the query

conn.Open()
        da = New OdbcDataAdapter("select poss_tenants.gerai_name, substring(detail_trans.trans_time, 1,6) as Bulan, detail_trans.item_name, sum(detail_trans.qty_item) as qty, detail_trans.price_exctax from poss_tenants inner join " & _
                                 "detail_trans on poss_tenants.poss_id=detail_trans.poss_id where detail_trans.trans_time between '" & date1.Text & "' and '" & date2.Text & "' and detail_trans.poss_id='" & possidtxt.Text & "' and detail_trans.type='ITEM' " & _
                                 "group by poss_tenants.gerai_name, substring(detail_trans.trans_time, 1,6),detail_trans.item_name,detail_trans.price_exctax order by qty asc limit 15", conn)
        ds = New DataSet
        ds.Clear()
        da.Fill(ds, "top15")
        conn.Close()
        dgv1.DataSource = (ds.Tables("top15"))
        conn.Close()