RE: Still need help on SELECT :)

Posted in 2000

William Rice — Thu, 15 Jun 2000 11:21:04 -0400 — source: Informix-list mailing list archive (1991-1998)

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/ ------------------------------------------------------------

↪ replying to William Rice

mars1972@my-deja.com — Thu, 15 Jun 2000 16:46:01 GMT — source: Informix-list mailing list archive (1991-1998)

FROM a, d, outer b, c, e ? In article <8iatqs$rib$1@news.xmission.com>, William Rice <ricew@operamail.com> wrote: > > 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/ > ------------------------------------------------------------ > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.