I have a query that is acting really funny. I am joining two tables. When I use a where clause everything comes back fine. When I add a group by clause I get no results. Is there a setting that I am missing? Also, If i run the statement with set ansi_nulls off it works. I am not using any isnull or comparing any nulls. I am basically selecting columns. If I remove the group by it works.
inner join table2
on table1.column1 = table2 = column2
group by .....