SportsDatabase.com

[EastCoastAts]

need help with the querys my programing skills are very novice
looking to compare between 2 teams ie 76ers@knicks when the line is less than 3 and total over 192
can u look at one team vs the other or just teams by themselves.i need help making the query
Thanks

[Meestermike]

You may wish to try asking your question here ... https://groups.google.com/group/sportsdatabase/topics

[mlfan]

team = Knicks and o:team = Seventysixers and site=home and (line < 3 and line > -3) and total>192

team name has to be capitalized. o: is for opponent's related info.

[EastCoastAts]

thanks where can i get list of all the abbrevations? i thought opponents was opp

[EastCoastAts]

thanks where do i find a list of abbrevations? i thought oppenent was opp

[BrUno0]

what's the difference between Rest 0&1 vs 1&1 vs 3&0 etc? I assume it's something rest and games in a row but not sure? Since i see some with 0&0..

[jrs362]

what's the difference between Rest 0&1 vs 1&1 vs 3&0 etc? I assume it's something rest and games in a row but not sure? Since i see some with 0&0..

It's the days rest for each team.

0&1 is 0 days rest for team and 1 day rest for their opponent.
1&1 is a 1 day rest for both teams.
3&0 is 3 days rest for team and 0 days rest for their opponent.