RE: Still need help on SELECT :)
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/ ------------------------------------------------------------