I have created a view in SQL that contains a rather complex query.
The query contains a cople of tables, joins etc and grouping
The problem is that it's just one field called ExecutionDate that i don't want for grouping or result
the only thing i want to do is a selection on it.
The problem is when i use the view from a query or from qrystal reports, i can not do a selection on that field since it is not in the views select statement.
How ever inside the view, createing a where clause is no problem