Re: Outer join syntax

Posted in 1998

Octavian Chiriac — Mon, 14 Dec 1998 20:26:30 +0200 — source: Informix-list mailing list archive (1991-1998)

Just: FROM A, OUTER B WHERE A.x=B.x Kind Regards, Octav Don Murray wrote: > > Does anyone know how to write an outer join that is compatible with Sybase > SQLAnywhere and Informix. > > The following works on SQLAnywhere. > > FROM A left outer join B on ( A.x = B.x ) > > What are the optional ways to write this for Informix? -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com