Adding London zones to season tickets

[Bertalan Eck]

Hi Guys,

I found a way to gather information for season tickets. However, there are different cases, when the destination is in London, so additional fares are shown.

For example: From Redhill to Denmark Hill. 3 tickets should be the result, where 2 are for London zones: zone 2-6 and zone 1-6. I figured out that I should use the zone_no or zone_ind columns, and need to do further queries.

My questions are:

1) How do I know I should look for tickets for zone 2-6 and zone 1-6?

2) Why just these 2 options? Why can't I get zone 2-3 or zone 2-5 prices as well?

Any help will be appreciated. Best regards,

Bertalan