Lookup values from one table to another based on a value

[koutoo at hotmail.com]

If I wanted to accomplish looking up values from one table based on a
value from another table or file, how would I go about doing this in
Python?  Would I build a dictionary or an array?

exp:

Table1:

Site = 103
Lane = 2
Dir = ?  # Get this from Table2

Table2:

Site, Lane, Direction,
103, 1, 1
103, 2, 1
103, 3, 5
103, 4, 5

Normally in Access I would just use a Dlookup and be done with it, or
use a Recordset in VB.  Thanks guys.

Kou