ForeverDC

Hi [img]smilies/smile.gif[/img]

I have the SQL code to a pretty simple query... and I need to write down exactly what it does.
The thing is, I don't have ANY knowledge of SQL.. I mean I can perform simple queries but I've never learnt the programming behind it. This is just one question from a bigger assignment.. but I can't figure it out.
Who can read this for me, and type up what it means?

SELECT [findadmin checked].pitnr, [findadmin checked].roomnr, [findadmin checked].unitnr, [findadmin checked].vlaknr, [findadmin checked].findnr, [findadmin checked].remarks, [findadmin checked].double
FROM [findadmin checked]
WHERE ((([findadmin checked].pitnr) In (SELECT [pitnr] FROM [findadmin checked] As Tmp GROUP BY [pitnr],[roomnr],[unitnr],[vlaknr],[findnr],[remarks] HAVING Count(*)>1 And [roomnr] = [findadmin checked].[roomnr] And [unitnr] = [findadmin checked].[unitnr] And [vlaknr] = [findadmin checked].[vlaknr] And [findnr] = [findadmin checked].[findnr] And [remarks] = [findadmin checked].[remarks])))
ORDER BY [findadmin checked].pitnr, [findadmin checked].roomnr, [findadmin checked].unitnr, [findadmin checked].vlaknr, [findadmin checked].findnr, [findadmin checked].remarks;

Thanks so much in advance!

Headhunter

Select = choosing columns of data
From = table that columns are located in
Where = criteria to determine which rows will be shown
Order by = order they are displayed in (heirarchy)