Newbie (actually my first project) here needs recommendations. There are 7 tables in Oracle. There are methods, measures, and data points. The methods are unique but can have multiple measures, and measures can have multiple data points. Where the extra tables come in is that the measures and data points also fall into one of three catagories; products, customers, or a combination. I need to display basic method information and allow browsing through the methods but I also need to display each measure and the associated data points attached to a method. I either need to list them all and identify the category of each or perhaps have the user choose the category (products, customers, or combo) and display only measures that exist for that method and category.
I would like to use a gridview but the SQL requires outer joins because every method does not necessarily have a measure from every category and nothing I have tried has worked.&n ...
Go to the complete details ...