Siebel Business Process & Functionality (MOSC)

MOSC Banner

Cartesian product

edited May 19, 2013 3:49PM in Siebel Business Process & Functionality (MOSC) 5 commentsAnswered

Hi Friends,

Why the below query making Cartesian product?

Select t3.*
from siebel.s_org_ext t1,siebel.s_party t2,siebel.s_postn t3,siebel.s_accnt_postn t4
where
t2.row_id = t1.par_row_id AND
t4.ou_ext_id = t2.row_id  AND
t4.position_id = t3.row_id  OR
t3.name = 'DEV W1'  OR
t3.name  = 'ERM AnonUser '   ;

Please could you share me more about when and how the Cartesian product made?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center