View not returning any data


View not returning any data

We have created a view selecting a number of fields from 5 different tables.
However, there's an issue when we include any one field from a specific table.
The issue is that "Select table1.field1, table2.field2 from table1, table2" does not seem to work and shows up as zero records. Strangely, "Select count(*) from table1, table2" tells us that there are a few million records in that view.

When we remove the field1 from the select statement, both the statements gives us consistant results and comes up with the equal number of records.

Would appreciate any help in this regards.