question

bijoy asked Nov 23, '18

pls solve the query

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 join union

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton ♦♦ commented · Nov 23, 2018 at 10:57 AM

what's your question?

0 ·

bijoy commented · Nov 23, 2018 at 11:01 AM

@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;

0 ·