What is the right classes (DAO, DTO, ...) for custom queries?

Hi!

If I have to get a data from my database, like:

SELECT log_id, logtype
FROM
 log
 logtype
WHERE
 log.logtypeid = logtype.logtypeid

Tables:

Log Table

log_id (PK)
log_type_id (FK)
...

Log Type Table

log_type_id (PK)
description (VARCHAR) 

Questions:

1 - In which class should I execute it? Should I add a method to my impl.LogDAO?

2 - The return from the method would be a DTO or BO?

PS: I'm not using Hibernate or any other ORM, I'm trying to generate my own code

Thanks