>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 R.RegionID, R.RegionName, O.OrderNo. O.OrderDate from myRegions R 
inner join myOrders O on R.RegionID = O.RegionID 
where O.OrderDate >=@StartDate and O.OrderDate < @EndDate

(drop @ sign if you're using local data)