table joins possible in expressions?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

table joins possible in expressions?

Postby locutus » Wed Aug 20, 2008 9:00 pm

Hi all,

I'm trying to access properties of the player that won the hand in tourney_holdem_hand_player_statistics, but this would require some sort of join because I want the id of the player from tourney_holdem_hand_summary.id_winner, not the id of the current player. Can this be done with expressions currently?

Thanks.
locutus
 
Posts: 6
Joined: Thu May 22, 2008 2:31 pm

Re: table joins possible in expressions?

Postby WhiteRider » Thu Aug 21, 2008 4:15 am

Not within PT3, no - Custom Stats can only access info about one player at once.
I guess it would be possible in SQL from PGAdmin or whatever, but I don't know how..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests