Need help with a report please :(

[susanstarr]

I need to add state does not equal Closed or In Audit.  Can anyone give me a leg up?

Select Top 1000000 htblticket.date As CreationDate,
htblticketstates.statename As State,
htblticket.agentid,
htblticket.ticketid,
htblticket.subject,
htblticket.fromuserid,
htblticket.ticketstateid,
htblticket.tickettypeid,
htblticket.accountid,
htblticket.lastuserreply
From htblticket
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid

[FrankSc]

Dear susantarr, 
Adding the where clause below should do that. 

Where htblticketstates.statename NOT IN ('Closed', 'In Audit')

Protip: Did you know that most current AI engines do an excellent job in adding or writing code?
Prompting your request in Copilot, for example, provides you with an accurate report within seconds.