RE: Problem with SELECT, please help

Posted in 2000

William Rice — Wed, 14 Jun 2000 18:09:00 -0400 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to William Rice

spammers_suck@my-deja.com — Thu, 15 Jun 2000 12:57:02 GMT — source: Informix-list mailing list archive (1991-1998)

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.