Good evening, I'm doing a project with connection to MySQL, I'm using the design patterns: MVC, DAO / VO.
I have several tables in my database, 11 in total, so I have 11 VO and 11 DAO, with which I make my queries and keep the information of them, now, in one of the views I need to show some information that joins two tables, I need some fields from table X and other fields from table Y, the way I solved this was creating a custom DAO / VO, where in the VO it mapped the data I needed to show from both tables, and in the DAO he carried out the respective consultations.
My specific question is: Is it correct to create a custom DAO which does not represent a table of the Database as such, but represents the union of several tables according to my need. Or am I violating some principle?
