In a view a want to select every rows that have the date = current date. How do I do this in a WHERE select?
I want to perform something like this:
Select * from Order
Where "SystemDate" = Order.Orderdate
How do I get the "SystemDate" ?
Thanks for any suggestions!