i have 2 tables , both having same table structure (i.e. same fields ) but having different Records. First Table for Male Candidate and another for Female Candidate.
both tables have 2 fields namely :- name and marks. Now i wanna write sql statement using adodb to perform the following:-
i wanna display all names(male and female) who secured at least 10 or higher.
Note:- i dont wanna use 2 recordsets for performing such a task . . .