Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advice on Join Strategy

Status
Not open for further replies.

PAULSGS

Programmer
May 10, 2002
63
0
0
US
Can someone shed some light upon the advantages and disadvantages of the joining strategies in BRIO 6.6?

There are these options

Use all joined Topics
Use the minimum number of Topics
Use all referenced Topics
Use defined Join paths
Use Automatic join path generator


A co-worker of mine advised me to use option 3, but it appeared to me that this didnÂ’t work, as I would have hoped.


I have a situation with three tables

Request-------<Request_Detail>-------Product_Family

I only wanted columns from Request and Product_Family but Brio advised me that the tables were not properly joined.

Would one of the other join options have equipped Brio with the power to join across a non SELECTed table?
 
Hello Paul, As your friend suggested it is the 3 option you need to use. What problem are you facing here ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top