Execute the following script, tip # # StartDate# and EndDate# is invalid, please comment how to modify the thank you very much!
Select
C.L oginID UserLoginId,
C.U serName UserName.
C.D PFullName DPFullName,
Arthur c. ardID UserInnerUID,
Amy polumbo eriodType PeriodType,
Amy polumbo osTime RunningAccountTime,
Amy polumbo osTime PosTime,
Amy polumbo osRegionID PosRegionID,
A. d. evName DevName,
Amy polumbo osMoney CostMoney.
A.A ccountPosDataID ToRunningAccountId,
A.C reateTime CreateTime
The from [Pos_AccountPosData] a
Left the join Pos_CardInfo b ON biggest ardNo=a.C ardNo
Left the join Sys_User c ON biggest ardUserID=c.U serID
Where a.C reateTime between # StartDate# and # EndDate#
The order by Amy polumbo osTime
]] & gt;