PGSQL：

      SELECT workstation.WORKSTATIONNAME AS "机器名", swl.softwarename "软件名称",osInfo.OSNAME AS "操作系统", net.ipaddress AS "IP地址" FROM SystemInfo workstation LEFT JOIN OsInfo osInfo ON workstation.WORKSTATIONID=osInfo.WORKSTATIONID LEFT JOIN Resource_Fields resFields ON workstation.WORKSTATIONID=resFields.RESOURCEID left join softwareinfo swi on workstation.workstationid=swi.workstationid left join softwarelist swl on swl.softwareid=swi.softwareid LEFT JOIN NetworkInfo net on net.workstationid=workstation.WORKSTATIONID order by 1