Informix SQL to SQL 2005

[nguyenl]

My task is to convert this Informix SQl Script to SQL 2005, unfortunately I am not really familiar with Informix SQL. Below is an example script. I can figure out the "Select" statement and the "Where" statement, but the "From" statement is giving me a hard time. Any assistance would be appreciated.Tha nks

set explain on;
UNLOAD TO '/export/home/permit/propinact.txt'
SELECT distinct property.parcel _number,
property.id,
property.eff_fr om_date,
property.eff_to _date,
property.situs_ address_id,
legal_lines.leg al_desc_line,
tax_code_area.t ca_number,
usecd.value,
ct.code_descrip tion,
property_char.v alue,
property.proper ty_status_cd,
legal_descripti on.section,
legal_descripti on.township,
legal_descripti on.range,
property.pact_c ode

FROM property,
OUTER (legal_descript ion, legal_lines),
outer property_char,
outer (property_char usecd, code_table ct),
tax_code_area,
prop_valuation

WHERE property.id = prop_valuation. property_id
AND property.id = legal_descripti on.property_id
AND property.eff_to _date <= TODAY
AND legal_descripti on.id = legal_lines.leg al_id
AND legal_lines.lin e_nr = 1
AND tax_code_area.i d = prop_valuation. tca_id
AND property.id = property_char.p roperty_id
AND property_char.p rop_char_typ_co de = "SIZE"
AND property.id = usecd.property_ id
AND usecd.prop_char _typ_code = "USECD"
AND usecd.value = ct.code_table_c d
AND property.pact_c ode <> 'PERS'

ORDER BY id