想创建一个临时表:
整合两个表:
normalUsers表:
normalUsersID int
normalUsersName char(32)
normalUsersPWD char(32)
normalUsersRegTime datetime
vipUsers表:
vipUserID int
vipUsersName char(32)
vipUsersPWD char(32)
vipUsersRegTime datetime 临时表的内容是:首先两张表的所有记录在一起按时间倒序排序整合,然后放到临时表里去!!,当然最好加一个字段mumberID(1,2,3,4,5),也就是字段递增!
临时表的结构大概是:
UserID,UsersName,UserPWD,UserRegt
希望高手指点?
整合两个表:
normalUsers表:
normalUsersID int
normalUsersName char(32)
normalUsersPWD char(32)
normalUsersRegTime datetime
vipUsers表:
vipUserID int
vipUsersName char(32)
vipUsersPWD char(32)
vipUsersRegTime datetime 临时表的内容是:首先两张表的所有记录在一起按时间倒序排序整合,然后放到临时表里去!!,当然最好加一个字段mumberID(1,2,3,4,5),也就是字段递增!
临时表的结构大概是:
UserID,UsersName,UserPWD,UserRegt
希望高手指点?
mumberID = Identity(Int, 1, 1),
*
Into #T
From
(Select
normalUsersID As UserID,
normalUsersName As UsersName,
normalUsersPWD As UserPWD,
normalUsersRegTime As UserRegt
From
normalUsers
Union All
Select
vipUserID,
vipUsersName,
vipUsersPWD,
vipUsersRegTime
From
vipUsers
) A
Order By
normalUsersRegTime DescSelect * From #T
normalUsersRegTime as UsersRegTime from normalUsers union all select * from vipUsers )A order by A.UsersRegTime