Hello Korrapati,

I'm guessing that you know SQL Server but not Informix.  If that is
the case then just remove the "dbo." from everywhere and the query
should work in Informix (if the tables exist in the same way in both
places).  Also cruise the web to read up on "Informix dbaccess".

L.S.

Gee, I wish someone would help me do my job too.

Try first, the come back with specific questions that would help you get through your issues.

Start here, http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp, then search for inner join. That should get you moving down the right path.

----- Original Message ----
From: korrapati <nkorrapati@gmail.com>
To: informix-list@iiug.org
Sent: Monday, September 29, 2008 2:58:06 PM
Subject: Translation to Informix Query

Can somebody please help translate this query ( for SQL Server ) for
use with Informix
SELECT DISTINCT
                     dbo.typeclass.name AS TypeClass,
dbo.device.name, dbo.device.description, dbo.devicenumplanmap.display,
dbo.numplan.dnorpattern,
                     dbo.typemodel.name AS TypeModel,
dbo.typedeviceprotocol.name AS TypeDeviceProtocol
FROM         dbo.typedeviceprotocol RIGHT OUTER JOIN
                     dbo.device RIGHT OUTER JOIN
                     dbo.numplan RIGHT OUTER JOIN
                     dbo.devicenumplanmap ON dbo.numplan.pkid =
dbo.devicenumplanmap.fknumplan ON
                     dbo.device.pkid = dbo.devicenumplanmap.fkdevice
LEFT OUTER JOIN
                     dbo.typemodel ON dbo.device.tkmodel =
dbo.typemodel.enum LEFT OUTER JOIN
                     dbo.typeclass ON dbo.typemodel.tkclass =
dbo.typeclass.enum ON dbo.typedeviceprotocol.enum =
dbo.device.tkdeviceprotocol
WHERE     (dbo.typeclass.name = 'Gateway') AND (dbo.typemodel.name <>
'H.323 Gateway')
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list