Can anyone please help me write this without using IN ?

```
SELECT firstname, lastname
FROM author
WHERE authorid IN (
SELECT authorid
FROM published_by JOIN written_by
ON written_by.bookdescid = published_by.bookdescid
WHERE  publisherid IN (3,746)
AND NOT written_by.role LIKE ('%translator%')
AND NOT published_by.role LIKE ('%editor%')
);

```

Struggling a bit here for a new SQL without using IN

Many thanks