Hi

I'm having a bit of a senior moment and for the life of me cannot get a select statement to work?!!??!

I have a table called myOrders, and in that there's a field called myOrders.RegionID. I also have a table called myRegions with the fields RegionID, RegionName.

I'm trying to build a cursor called MyResults that selects a date range from myOrders table, and then uses myOrders.RegionID to pull in the field MyRegion.RegionName.

MyResults should look something like:

myResults.OrderNo
myResults.OrderDate
myResults.RegionID
myResults.RegionName

Help, it's driving me bonker??!?