select (select name from tchr union select name from student)student.gender as ag,tchr.gender as og from student join tchr on student.course=tchr.course;
select (select name from tchr union select name from student)student.gender as ag,tchr.gender as og from student join tchr on student.course=tchr.course;
@thomasruston. I want this query to write in proper format
select (select name from tchr union select name from student)student.gender as ag,tchr.gender as og from student join tchr on student.course=tchr.course;
17 People are following this question.