Jeff,
Thaks for the reply, let me sum up. Normal order if by CaseID, However,
we have a need to order it by FileNumber (Keeps all the Assignments for One
person together). Assignments for one person may come in over the course of
Months so I can't order it by CaseID. The reason I want
Hi Roger,
Quick rundown.
Table:
Assignments
CaseID auto_increment
FileNumber char(18)
FirstName char(20)
LastName char(20)
and on and on and on
Indexes on
CaseID (Primary)
FileNumber
Name (LastName, FirstName)
What I would like to do is something along the lines of
SELECT CaseID
Quick rundown.
Table:
Assignments
CaseID auto_increment
FileNumber char(18)
FirstName char(20)
LastName char(20)
and on and on and on
Indexes on
CaseID (Primary)
FileNumber
Name (LastName, FirstName)
What I would like to do is something