50 Query Series-11th query: Query at least one course with the student number "1001" Students learn the same student number and name;

Select distinct  from tblstudent, Tblscore where  in (the select from where Tblscore.    Stuid='1001'  ) and Tblstudent. Stuid=tblscore. Stuid

The answer is provided in two ways;

1:

Select DistInct  from Tblstudent St   Inner Join  on St. Stuid=SC. Stuid   where in (SelectfromWhere stuid=  '1001')

2:

-- ----nested subqueries Select  from tblstudent   Where inch   (   SelectDistinctfromWhere in (  SelectfromWhere stuid='1001')  )

50 Query Series-11th query: query has at least one class with the student number "1001" Students learn the same student number and name;