SELECT DName FROM DEPARTMENT WHERE Division  =  "AS" UNION SELECT DName FROM DEPARTMENT WHERE Division  =  "EN" AND Building  =  "NEB"
What are the names of departments either in division AS, or in division EN and in building NEB?
SELECT DName FROM DEPARTMENT WHERE Division = `` AS '' UNION SELECT DName FROM DEPARTMENT WHERE Division = `` EN '' AND Building = `` NEB ''
select dname from department where division = value union select dname from department where division = value and building = value
What are the names of departments either in division AS , or in division EN and in building NEB ?