I'm a newb to Informix and trying to convert the following statement to SQL Server (2005). The problem is the join. From what I've been able to find, it appears that Informix outer joins are left outer joins by default, so I'm pretty sure a "LEFT OUTER JOIN" needs to be there somewhere. The problem is the rest of the join syntax. Can anyone help?

Informix query:
Code:
SELECT it.lnum, it.vid, it.cc 
FROM it,
...