Database Question

[Bigtiger]

How do you query previous matchup results vs the same team

For example if the Dodgers lose to the Giants tonight, how do I get the results of how the Dodgers do vs the Giants when they lost the last time they played the Giants

Not sure why this one is giving me so much trouble but not figuring it out

Any help greatly appreciated

[jumperjack]

Re: Database Question

How do you query previous matchup results vs the same team

For example if the Dodgers lose to the Giants tonight, how do I get the results of how the Dodgers do vs the Giants when they lost the last time they played the Giants

Not sure why this one is giving me so much trouble but not figuring it out

Any help greatly appreciated

https://killersports.com/mlb/query?s...+S+D+Q+L+%21++

[jumperjack]

Re: Database Question

team=Giants and o:team=Dodgers and P:L and SG>1 to find that result within the same series.

[Thomas]

Re: Database Question

Right answer from Jack with P:L, (team=Giants and Po:team=Dodgers and P:L) but you may find this useful for a complete look with some future games Darryl, team=Giants and Po:team=Dodgers?show_games=300

?show_games=300 at end of query is just to show more games

[Bigtiger]

Re: Database Question

https://killersports.com/mlb/query?s...+S+D+Q+L+%21++

So the Capital P brings the result the previous time those same two teams played, where a small p brings results from their previous game regardless of opponent?

[Bigtiger]

Re: Database Question

Right answer from Jack with P:L, (team=Giants and Po:team=Dodgers and P:L) but you may find this useful for a complete look with some future games Darryl, team=Giants and Po:team=Dodgers?show_games=300

?show_games=300 at end of query is just to show more games

Awesome, thanks for that too Tom!

[Thomas]

Re: Database Question

So the Capital P brings the result the previous time those same two teams played, where a small p brings results from their previous game regardless of opponent?

Correct