Possibility of creating multiple join between two tables

Pls could someone help me out on the downside of creating two or more join relationships between two tables in a database and in business objects universe creation. Is it really ok and possible to create more than one join?

Thanks a lot .

Olusoga

Systems Analyst

If you mean that you want to have more than one column in the relationship, the answer is yes. That possible in SQL Server and very common as PK can contain more than one column. I doubt that this is not supported in any OR mapper like Business Objects.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de