SQL Help

[dennisa]

Hello Holdem Manager Support,

I just wrote the following query in PGadmin for a custom report I am trying to create. I would like add the stat of attempted to steal, but did not see it in the tables. Would you help me derrive which fields I need to gather to render that stat. The SQL below is what I am using to start my custom report.

Thanks

select p.playername, cr.totalplayedhands, cr.compiledplayerresults_id, cr.playedonmonth, cm.totalhands, cm.vpiphands, cm.pfrhands,
g.gametypedescription
from players p, compiledresults_month cr, compiledplayerresults_month cm, gametypes g
where p.player_id = cr.player_id and cr.compiledplayerresults_id = cm.compiledplayerresults_id and cr.gametype_id = g.gametype_id and
cr.playedonmonth >= '200812' and p.cashhands > 500 and g.istourney = false
order by playername

[morny]

Please check the stickies in the custom reports section of the forum, theres tons of info there and you should find what your looking for