SELECT T1.stu_fname FROM student AS T1 JOIN enroll AS T2 ON T1.stu_num  =  T2.stu_num JOIN CLASS AS T3 ON T2.class_code  =  T3.class_code JOIN course AS T4 ON T3.crs_code  =  T4.crs_code JOIN department AS T5 ON T5.dept_code  =  T4.dept_code WHERE T5.dept_name  =  'Accounting' INTERSECT SELECT T1.stu_fname FROM student AS T1 JOIN enroll AS T2 ON T1.stu_num  =  T2.stu_num JOIN CLASS AS T3 ON T2.class_code  =  T3.class_code JOIN course AS T4 ON T3.crs_code  =  T4.crs_code JOIN department AS T5 ON T5.dept_code  =  T4.dept_code WHERE T5.dept_name  =  'Computer Info. Systems'
Find the first name of student who is taking classes from accounting and Computer Info. Systems departments
SELECT T1.stu_fname FROM student AS T1 JOIN enroll AS T2 ON T1.stu_num = T2.stu_num JOIN CLASS AS T3 ON T2.class_code = T3.class_code JOIN course AS T4 ON T3.crs_code = T4.crs_code JOIN department AS T5 ON T5.dept_code = T4.dept_code WHERE T5.dept_name = 'Accounting ' INTERSECT SELECT T1.stu_fname FROM student AS T1 JOIN enroll AS T2 ON T1.stu_num = T2.stu_num JOIN CLASS AS T3 ON T2.class_code = T3.class_code JOIN course AS T4 ON T3.crs_code = T4.crs_code JOIN department AS T5 ON T5.dept_code = T4.dept_code WHERE T5.dept_name = 'Computer Info . Systems '
select t1 . stu_fname from student as t1 join enroll as t2 on t1 . stu_num = t2 . stu_num join class as t3 on t2 . class_code = t3 . class_code join course as t4 on t3 . crs_code = t4 . crs_code join department as t5 on t5 . dept_code = t4 . dept_code where t5 . dept_name = value intersect select t1 . stu_fname from student as t1 join enroll as t2 on t1 . stu_num = t2 . stu_num join class as t3 on t2 . class_code = t3 . class_code join course as t4 on t3 . crs_code = t4 . crs_code join department as t5 on t5 . dept_code = t4 . dept_code where t5 . dept_name = value
Find the first name of student who is taking classes from accounting and Computer Info . Systems departments