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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cartesian Product error

Status
Not open for further replies.

Jsadas

Programmer
May 27, 2003
31
US
I am getting the following error
' Query will create a Cartesian Product Do you want to continue '
If I click OK, the results are coming fine. But I am not sure of why this message is coming.

The field that is causing this problem is max(( DM_EXTRACT.LOAD_FINISH )and it is from the table DM_EXTRACT.

Below is my Query
SELECT
DM_VW_BUDGET_UNIT_DIM.description,
DM_VW_WORK_ATTRIBUTE_DIM.WBS30,
DM_VW_WORK_ATTRIBUTE_DIM.WBS20_CODE,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS38,
DM_VW_WORK_ATTRIBUTE_DIM.WBS39,
max(( DM_EXTRACT.LOAD_FINISH ))
FROM
DM_EXTRACT,
DM_VW_BUDGET_UNIT_DIM,
DM_VW_WORK_ATTRIBUTE_DIM,
DM_VW_NOTES_DIM,
DM_BUDGET_DATA_FACT
WHERE
( DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE=DM_VW_BUDGET_UNIT_DIM.BUDGET_UNIT_CODE )
AND ( DM_VW_WORK_ATTRIBUTE_DIM.ACTIVITY_CODE=DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE )
AND ( DM_VW_NOTES_DIM.ACTIVITY_CODE(+)=DM_BUDGET_DATA_FACT.BUDGET_UNIT_CODE )
AND ( DM_VW_WORK_ATTRIBUTE_DIM.WBS30 = @Prompt('Select the Project Report Type','C','Project Alternate Structures\Project Report Type',Mono,) )
GROUP BY
DM_VW_BUDGET_UNIT_DIM.description,
DM_VW_WORK_ATTRIBUTE_DIM.WBS30,
DM_VW_WORK_ATTRIBUTE_DIM.WBS20_CODE,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS40,
DM_VW_WORK_ATTRIBUTE_DIM.WBS38,
DM_VW_WORK_ATTRIBUTE_DIM.WBS39

Please update on how to get rid of this message. I looked at some previous solutions that point to Joins, I tried defining a Join DM_EXTRACT & DM_VW_BUDGET_UNIT_DIM (one of the existing tables) I am still getting the same error.

Any help would be appreciated.

Regards
Jags
 
Please ignore the above problem, I found the solution..
I had created a Default Join (which is always true)and it worked.

Rgds
Jags
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top