Clif
asked on
Adding a "pseudo record" to a view.
I have a view, something like:
SELECT DISTINCT Salesman FROM SalesReport
This gives me the proper list. However, I need to add one record that does not exist in the SalesReport table, that is "--ALL--" (It's for an issue with Crystal Reports, if you really need to know)
Can I do this? How?
SELECT DISTINCT Salesman FROM SalesReport
This gives me the proper list. However, I need to add one record that does not exist in the SalesReport table, that is "--ALL--" (It's for an issue with Crystal Reports, if you really need to know)
Can I do this? How?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for jarring my memory.