hi, here is my data base structure:
i try an sql command that return for each examen its number of tests, so i tried:
Dim sqlQRY1 As String = "SELECT Int_Exa,count(*) as 'TOTAL' from TEST T1,TEST T2 where T1.Int_Exa=T2.Int_Exa"
that`s did not work, so i tried to do that:
Dim sqlQRY1 As String = "SELECT EXAMEN.Int_Exa,count(Id_Test) from EXAMEN,TEST where EXAMEN.Int_Exa=TEST.Int_Exa"
these two gives me error, i hope you help me to find the appropriate sql command ;)