Quote Originally Posted by toraj58
i think that for his problem DataRelation and SQL Join are interchangable.
NO, they are radically different. In the first case, the relationship only exists inside the application. In the second case, there is only a single entity in the application and the merge occurs within the database.

The differences between these two are quite significant. Each is applicable to DIFFERENT situations.

Because of the updating in the OP's requirements, it appears that keeping them as distinct entities (ie jusing a DataRelation and NOT a join) is the more appropriate.