SELECT * FROM Formum_Child a INNER JOIN

 (SELECT pid, MAX(DateSubmitted) DateSubmitted FROM Forum_Child GROUP BY pid) b

 ON a.pid=b.pid AND a.DateSubmitted=b.DateSubmitted

SELECT Customer, SUM(InvoiceAmt) TotalSales, COUNT(Invoice) NoOfInvoices, Month, SUM(CreditNoteAmt) TotalCreditNote,

 COUNT(CreditNote) NoOfCreditNotes

FROM

(SELECT NBillingF.Customer,

 CASE WHEN NBillingF.InvoicedValue > 0 THEN NBillingF.InvoicedValue ELSE 0 END AS InvoiceAmt,

 CASE WHEN NBillingF.InvoicedValue > 0...

select d.DepartmentName, e.*

from Department d

join Employee e on e.DepartmentId = d.DepartmentId