I need to create a SQL Statement that will display all students that have taken Eng 1010 AND 1020...I used crse_code In ("1010","1020")...but the works more like an OR than an AND. It returns all rows of students that have only taken one of the classes...for instance just 1010 and not 1020. Does anyone now of a way around this?
Thanks,
Thanks,