本文介绍了使用DayNames对值进行排序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
朋友，我这样写查询...
HI friends I write the query Like This...
SELECT Subjects.SubName,DayTable.DayName FROM ClassRoom INNER JOIN Cst ON ClassRoom.ClassId = Cst.ClassId INNER JOIN newTimeTable ON Cst.CstId = newTimeTable.CstId INNER JOIN ClassHours ON newTimeTable.HourId = ClassHours.HourId INNER JOIN Subjects ON Cst.SubjectId = Subjects.SubjectId INNER JOIN DayTable ON newTimeTable.DayId = DayTable.DayId where HourName='5th Hour' and ClassName='1st Class' ORDER BY DayTable.DayName
我对此有问题.
当我使用此查询时，它从基于(FriDay，MonDay，TueDay ....)的DayNames中获取记录.但是我想要(Monday，TesDay，WedDay ...)以这种形式有人请帮助我....
I have a problem with this..
When I Use this query it fetches the records from DayNames Based On(FriDay,MonDay,TueDay....) But I want(Monday,TesDay,WedDay...)In this form Anyone pls help me....
推荐答案
这篇关于使用DayNames对值进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！