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'));