I assume you are familiar with MS SQL Server because SQL on itself is the general language all (or almost all) relational databases use.
You can find all sql command in the sql manuals from informix. You can download them from the IBM site.
URL: www-306.ibm.com/software/data/informix/pubs/library/ids_94.html
But the syntax itself is quite general. Informix join method is a little bit different (especially the outer join) but evrything is in the manuals.
Hope this helps,
Rob Prop