>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??!?

select  myOrders.OrderNo, ;
            myOrders.OrderDate, ;
           myOrders. RegionID, ;
          myRegions.RegionName ;
   from myOrders ;
        join myRegions  on ( myOrders.RegionID = myRegions.RegionID ) ;
  where ( OrderDate between ?date1 and ?date2 )