SQL-Question: Error 393

Dear SQL-Gurus, somehow I cannot get my act together with the following query: select teamnr[1], bezeich from team where teamnr matches "?000" into temp ort; select teamnr[1,3], bezeich from team where teamnr matches "*0" and teamnr not matches "?00?" into temp klinik; select team.druck, nverteil.folge, nverteil.tage, team.bezeich tbezeich, klinik.bezeich kbezeich, ort.bezeich obezeich, personal.vollname, team.zahl from team , OUTER nverteil, personal, OUTER klinik, ort 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 | | +--------------------------+------------------------------------------+