View and Grouping
Hi!
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
Any ideas?
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
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.