Hi, I'm no expert in SQL but I'm running this query in query analyzer in sql server 2000 and its taking forever ( I havent been able to sit long enough to see if it times out ) anyways heres the query :

select distinct partyname,resppartynm,judgment1.casenumber,judgmentdate,judgmentEventCodeDescription,Descr iptionError,disp,judgment2.jseq from judgment1,judgment2 where judgmentdate between '9/11/2000' and '9/12/2000'and judgment2.inf = 1 or judgment2.inf = 2


I dont know if its the way I wrote it or what but its just sits there taking forever to finish executing (which again, I've never sat long enough to see it finish ) Help !