Informix SQL查询:返回不同结果的两个类似查询

I have an Informix SQL query which returns a set of rows. It was slightly modified for the new version of the site we've been working on and our QA noticed that the new version returns different results. After investigation we've found that the only difference between two queries were in the number of fields returned.I have an Informix SQL query which returns a se