Ron Ready
|
| Posted: 07/13/2001, 6:19 AM |
|
Iam creating my own sql statement to join two tables, when I add the Order
by clause, the program will not work, It just hangs, when I paste the sql
statement into mssql2000 the statement works and brings up the record set.
Can some on help me with this, I will past the statement below.
Select Invprcs.Inventoryprice, Invmstr.WeekNumber, Invmstr.ArrivalDate,
Invmstr.DayofWeek, Invmstr.Unitsize, Invmstr.DepartureDate,
Invmstr.ResortName, Invmstr.ResortGeneralArea, Invmstr.ResortState From
Invprcs, Invmstr Where Invmstr.Inventorynumber = Invprcs.Inventorynumber and
Invprcs.InventoryPriceType = 'Hot Week' Order by Invmstr.WeekNumber
Note if I take out the Order by clause It works, of course it is not sorted
correctly.
|
|
|
 |
|
