You can create objects with data from multiple tables. In the standard objects the objects are always created for one table only.
‣
‣
‣
How-To: Creating objects with data from multiple tables (combined DSO)
Create custom entity with all desired fields.
Create DSO out of the entity.
Configure DSO and Create needed objects out of the DSO