order by question

[rds80]

Lets say I have a query:

SELECT N.NoteID,
 CM.DealName
 (SELECT C.FirstName + ' ' + C.LastName
  FROM tblContact C
  INNER JOIN tblSecUser SU
     ON C.ContactID = SU.ContactID_F
  WHERE SU.userid = tblControlMaster.UserID_F) AS Originator
FROM tblControlMaster CM
INNER JOIN tblNote ON CM.ControlID = N.ControlID_F

and now I want to order by C.FirstName and C.LastName. Would I be able to ORDER BY Originator?

Thanks.

 

[rds80]

actually that works, ignore the question above.

 

[gmmastros]

A quick and dirty way...

Select NoteId, DealName, Originator
From   (
       SELECT N.NoteID,
        CM.DealName
        (SELECT C.FirstName + ' ' + C.LastName
         FROM tblContact C
         INNER JOIN tblSecUser SU
            ON C.ContactID = SU.ContactID_F
         WHERE SU.userid = tblControlMaster.UserID_F) AS Originator
       FROM tblControlMaster CM
       INNER JOIN tblNote ON CM.ControlID = N.ControlID_F
       ) as A
Order By Originator

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[rds80]

Thats pretty cool, George.
Never thought it could be done that way.