Question by bijoy · Nov 23, 2018 at 06:50 AM · select join union

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;

0 Show 2

10 |1200 characters needed characters left characters exceeded

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

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

Share

what's your question?

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

Share

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

Copyright 2019 Redgate Software. Privacy Policy