SELECT DISTINCT Period
FROM tInvoice, tInvoiceDetail
where tInvoiceDetail.InvoiceID = tInvoice.ID
  and tInvoice.InvoiceDate > dateadd(dd,9,'20120630')
  and tInvoice.InvoiceDate <= dateadd(mm,1,dateadd(dd,9,'20120630'));