with arcpy.da.SearchCursor(table1,["Code1","Code2","Code3"],where_clause = sqlfinal) as curtable:
                    for rowt in curtable:
                        s = rowt[1]
                        with arcpy.da.SearchCursor(table2,["Name","Code2","Code4"]) as curs:
                            for rows in curs:
                                if rows[1] == rowt[1]:

                                   vtab.append([rowt[0],rows[0],rowt[2]])
                            parameters[5].value = vtab