Making a query

[kmasonbx]

I need to do a tax query, and I have what I think is the text needed to make the query but I have no idea where I'm supposed to input the text.

Here is the text that I have, is this right?

SELECT date_part('month',s.session_start) AS SessionMonth, date_part('day',s.session_start) AS SessionDay, date_part('year', s.session_start) AS SessionYear, SUM(amount_won) AS AmountWon
FROM players AS p INNER JOIN session AS s ON s.player_id=p.player_id
WHERE p.screen_name='SCREENNAME' AND date_part('year', s.session_start) = YEAR
GROUP BY SessionMonth, SessionDay, SessionYear
ORDER BY SessionYear, SessionMonth, SessionDay;

Change SCREENNAME, YEAR to your main screenname in PT2 and the tax year in question.

[ptrack pat]

You need to use the pgAdmin program to connect to your database and run the query. Go to the Start > Programs > PostgreSQL > pgAdmin then right-click on the red X and select connect from the popup menu. Enter your PostgreSQL password when prompted. Then click on your database and then under the Tools menu select Query Tool. Enter this SQL statement into the next window.

[kmasonbx]

I did this but when I highlight my database and click on tools the query tool option isn't selectable. The only selectable options are connect, stop service, reports, server configuration and server status. Am I doing something wrong?

[ptrack pat]

If you are connected to the database then it should be enabled. What database are you clicking on? Is there a red X next to it? If there is a red X next to it you aren't connected.

[kmasonbx]

I was just in the wrong place got the query tool to come up. However that query doesn't seem to be working. Is something wrong within the text? If so do you know a query that will work in order to have my wins and losses seperated for each month for 2008?

[ptrack pat]

Is it giving you an error message?

[kmasonbx]

It was my error, I was changing the wrong 'year.' It worked, thanks for all your help.