Need schema help

[travisp33]

Hey guys - I need a query that will provide the following, but I am lost. Please move to the appropriate forum if this is not the place for it. I want to run the query directly against the DB, so normal sql is fine, not a 'report'.

I want to see every hand in the database where the holecards are known, and the players were all in pre-flop for at least 50BB.

Can anyone help me out? I can write the sql (DBA by trade), just not sure what columns I should be going after.

Thanks

[morny]

Although your not looking for a report, there is alot of information in the Custom Reports section in the stickies which explains about all the tables, check that out and if you cant find what you need there let me know and ill ask Roy