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')
>> Stay informed about: Translation to Informix Query