Re: OUTER JOINS in Informix SQL

On Thu, 28 Oct 1999 18:22:41 GMT, "Lance King" <lance.king@definition6.com> wrote: >I am trying to run a SQL query against an Informix DB (INFORMIX 5.10.UC1) >from ASP. Normal queries work fine, but when I try to do an outer join I >get syntax errors. I have tried several different flavors of outer joins >(i.e. the ANSI version, the "*=" version). Can someone please help? > >Here is the sql statement (ANSI Version): > >SELECT > tblTemplateHeader.Name AS TemplateName, > tblTemplateHeader.ID AS TemplateID, > tblTemplateItem.ItemID AS ItemID, > tblTemplateItem.Sequence AS LineNumber, > tblItem.ItemCode AS ItemCode, > tblItem.ItemDscr AS ItemDscr > FROM > ( > tblTemplateHeader > LEFT OUTER JOIN tblTemplateItem > ON tblTemplateItem.TemplateID = tblTemplateHeader.ID ) > LEFT OUTER JOIN tblItem > ON tblItem.ID = tblTemplateItem.ItemID > WHERE tblTemplateHeader.ID IN (88) > ORDER BY > tblTemplateHeader.TemplateName, > tblTemplateItem.Sequence > I believe that Informix did not support the "LEFT OUTER JOIN" syntax until IDS 7.31.x They mention it on the web site. -Peter