Request - Helpdesk report showing tickets opened yesterday with description

[Null]

I would like help with creating a report that shows:

All new tickets opened in the previous calendar day (Example, if I ran the report Thursday, it would show me all Wednesdays tickets)

The Agent the ticket is assigned to

Which user it concerns (Who requested help/is needing help)

Ticket Subject

And Ticket Description

I would appreciate any help with this.

[poweld1]

I copied and pasted this but am getting this error message, any idea?

Invalid SELECT statement. Unexpected token " Inner" at line 12, pos 1.: Unexpected token " Inner" at line 12, column 1

[Niko0]

Select Top 1000000 htblticket.date As [Date Created],
  htblusers1.name As Agent,
  htblusers.name As Requester,
  htblticket.subject As Subject,
  htblnotes.note As Description
From htblticket
  Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
  Inner Join htblusers On htblusers.userid = htblticket.fromuserid
  Inner Join htblticketstates On htblticketstates.ticketstateid =
    htblticket.ticketstateid
  Inner Join htblagents On htblagents.agentid = htblticket.agentid
  Inner Join htblusers htblusers1 On htblusers1.userid = htblagents.userid And
    htblusers.userid = htblnotes.userid
Where htblticket.date > GetDate() - 1