RE: Still need help on SELECT :)

I suspect the problem is due to a table not joined in the were clause. Definition of a cartesian product from Informix Tutorinal -- When you perform a multiple-table query that does not explicitly state a join condition among the tables, you create a Cartesian product. A Cartesian product consists of every possible combination of rows from the tables. This result is usually large and unwieldy, and the data is inaccurate. -- I believe the definition of an outer cartesian product is when you have a cartesian product between A and B as well as an outer join. The system is saying why are you doing an outer join when you are not even constraining on the tables in the where clause. An example of this in work is select * from syssynonyms, systables;Result: 0 rows found select * from syssynonyms, outer systables;Result: The where clause contains an outer Cartesian Product. Hope this helps, Will >===== Original Message From "Martin, Wayne E." <WMartin@kmart.com> ===== >are you trying to do: > >FROM a,b outer c,d,e ??? > > > > >-----Original Message----- >From: William Rice [mailto:ricew@operamail.com] >Sent: Thursday, June 15, 2000 11:21 AM >To: informix-list; spammers_suck@my-deja.com >Subject: RE: Still need help on SELECT :) > > >That doesnt make sense to me. Would you please send the full query to >the group? > >Will >>===== Original Message From spammers_suck@my-deja.com ===== >>Its a strnge thing. >> >>I want do : >> >>FROM a, outer b, outer c, (d, outer e) >> >>Informix insists that I do : >> >> >>FROM a, outer b, outer c, outer (d, outer e) >> >> >>But I don't want d to be an outer join with a ! It returns unwanted >>"extra" rows. >> >>Any ideas? >> >>Why this apparent limitation? >> >>Thanks :) >> >> >> >>In article <8i920i$a4u$1@news.xmission.com>, >> William Rice <ricew@operamail.com> wrote: >>> >>> Actually, I imagine the problem is in your where clause. You do >>> not have one of the tables joined in, would you post your where clause >>as >>> well? >>> >>> Will >>> >===== Original Message From spammers_suck@my-deja.com ===== >>> >MY SQL brain seems to be taking a vaction. >>> > >>> >I've got a problem with a SELECT : >>> > >>> >The from clause is >>> > >>> >FROM >>> > A, OUTER D,OUTER E,B,OUTER C >>> > >>> >It complains about an outer caretisan product (not surprisingly). >>> > >>> >I need A to be the master table and D, E & B to be subservient to it. >>> >However C has to be >>> >subservient to B and I don't want an outer join between A and B. >>> > >>> >I've tried using brackets to no avail - syntax errors >>> > >>> >Any ideas? >>> > >>> > >>> > >>> >Sent via Deja.com http://www.deja.com/ >>> >Before you buy. >>> >>> ------------------------------------------------------------ >>> This e-mail has been sent to you courtesy of OperaMail, as a free >>service from >>> Opera Software, makers of the award-winning Web Browser, Opera. >>Visit us at >>> http://www.opera.com/ or our portal at: http://www.myopera.com/ Your >>free e-mail >>> account is waiting at: http://www.operamail.com/ >>> ------------------------------------------------------------ >>> >>> >> >> >>Sent via Deja.com http://www.deja.com/ >>Before you buy. > >------------------------------------------------------------ >This e-mail has been sent to you courtesy of OperaMail, as a free >service from >Opera Software, makers of the award-winning Web Browser, Opera. Visit us >at >http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free >e-mail >account is waiting at: http://www.operamail.com/ >------------------------------------------------------------ ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------