Dim strQuery As String
Dim rs1 As ResultSet
strQuery = $"SELECT DISTINCT surn FROM names ORDER BY surn "$
rs1 = SQL.ExecQuery2(strQuery, Null )
Do While rs1.NextRow
Dim mysurname As String = rs1.GetString("surn") 'this will be the title
Dim rs As ResultSet = SQL.ExecQuery2($"SELECT A.surn AS Surname, A.givn AS Fullname, B.sex AS Sex FROM persons B
JOIN names A ON B.id = A.id_p WHERE Surname LIKE ?
ORDER BY Surname "$ _
, Array As String (mysurname))
Do While rs.NextRow
Log($"${rs.getstring("Surname")}${TAB}${rs.getstring("Fullname")} ${TAB}${rs.getstring("Sex")}"$)
Loop
rs.Close
Loop
rs1.Close