SELECT DISTINCT CHARGE, NO FROM student, teacher WHERE CHARGE = ID and NO = '" & myDataNvocc.Tables(0).Rows(y).Item("ID") & "' and CHARGE is not null
Btw the
'" & table1.Tables(0).Rows(y).Item("ID") & "'
is from dataset and i want use this in stored procedure
y is from this
For y = 0 To table1.Tables(0).Rows.Count.ToString() - 1
What I have tried:
Pls help me i really have no idea