Hi guys, I've been trying this for hours but keep getting the same error. I'm trying to join the tables, but eliminate repeated data, hence the group by function.
The SQL is as follows:
select d.directorno, name
from film f, director d
where f.directorno=d.directorno and genre !='SCIENCE FICTION'
group by d.directorno
Without the group by function, it gives me repeated entries, does anyone have any idea on how to fix this?