Problem writing sql statement....

I have a table that I want to find rows that have the same value in two fields, e.g. all rows that have the same date
andalso the 
same productionid...
How do I write such an sql statement?


Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------