I have two tables with the following structures:

Table1:
DivisionName C(30)
Access N(1)



Table2: Contains information on all divisions
DivisionId N(5)
DivisionName C(30)
Address C(50)
Etc....

What I want to do is gather the DivisionId's for only the DivisionName's listed in Table1.

I tried "Select DivisionId FROM Table2 INTO CURSOR tmpCursor WHERE table1.DivisionName = table2.DivisionName" but this does not seem to work.

What am I doing wrong?

Thanks in advance for your help,
Russell Clendenon