>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 )
Gregory