Re: SQL-Question: Error 393

Richard Spitz wrote: > > Dear SQL-Gurus, > > select > team.druck, > nverteil.folge, > nverteil.tage, > team.bezeich > tbezeich, > klinik.bezeich > kbezeich, > ort.bezeich obezeich, > personal.vollname, > team.zahl I see a problem here... > from team , OUTER nverteil, personal, OUTER klinik, > ort Try this: from team, personal, ort, OUTER (nverteil, klinik) > where team.druck between 0 and > 249 > and team.teamnr = > nverteil.teamnr > and nverteil.persnr = > personal.persnr > and nverteil.teamnr = > ort.teamnr[1] > and nverteil.teamnr = > klinik.teamnr[1,3] > and nverteil.woche = > "29.09.1997" > order by druck, kbezeich, > folge > > This query gives me SQL error -393: > "A condition in the where clause results in a two-sided outer join.". > > What is a "two-sided outer join"? Can a SQL-Guru tell me which condition > is the offending one? If you need more info about the underlying tables, > please let me know. > > This happens with Online 5.07 as backend, in case that makes any > difference. > > Thanks for any help, > Richard > -- > +--------------------------+------------------------------------------+ > | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | > | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | > | Klinikum Grosshadern | FAX : +49-89-7095-8886 | > | 81366 Munich, Germany | | > +--------------------------+------------------------------------------+ -- ---- Chuck Ludwigsen <cludwigs@hotmail.com> Database Engineer <cludwigsen@harrahs.com> Harrah's Entertainment, Inc. President - Memphis Informix User's Group <miug@hotmail.com> ** My opinions are my own and sometimes conflict with those of my employer **