22,300
社区成员




SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.BusTour
SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.CountryTour
select * from(SELECT PeopleNumber, TheMoney, BusTour.GroupNumber, AddDate,LoginName,GroupStyle FROM dbo.BusTour JOIN dbo.GroupLine ON dbo.BusTour.GroupNumber = dbo.GroupLine.GroupNumber
union all SELECT PeopleNumber, TheMoney, CountryTour.GroupNumber, AddDate,LoginName,GroupStyle FROM dbo.CountryTour JOIN dbo.GroupLine ON dbo.CountryTour.GroupNumber = dbo.GroupLine.GroupNumber) t
where LoginName='admin' and AddDate between '2013-07-18' and '2013-07-22'
SELECT *
FROM
(
SELECT PNumber, TMoney, GNumber, AddDate,LoginName FROM dbo.BusTour
UNION
SELECT PNumber, TMoney, GNumber, AddDate,LoginName FROM dbo.CountryTour
) A
WHERE A.LoginName='yewu1'
select * from
(SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.BusTour
union all
SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.CountryTour) t
where LoginName='yewu1' and AddDate between [开始时间] and [结束时间]
select * from
(SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.BusTour where LoginName='yewu1'
union all
SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.CountryTour where LoginName='yewu1') t
select * from dbo.BusTour where LoginName='yewu1' union select * from dbo.CountryTour where LoginName='yewu1'
PNumber TMoney GNumber AddDate LoginName
1 444 22444 2013-07-19 15:51:41.000 admin
2 222 22 2013-07-19 15:51:00.000 admin
34 3434 22444 2013-07-19 16:07:21.000 admin
1 500 201307 2013-07-26 09:01:44.000 yewu1
1 200 22 2013-07-19 16:31:42.000 admin
我现在想得到LoginName='yewu1'的2表中所有数据
PNumber TMoney GNumber AddDate LoginName
1 120 1212121 2013-07-18 16:49:38.000 yewu1
1 33 1111111 2013-07-11 11:40:58.000 yewu1
1 500 201307 2013-07-26 09:01:44.000 yewu1
SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.BusTour where LoginName='yewu1'
UNION ALL
SELECT PNumber, TMoney, GNumber, AddDate,LoginName
FROM dbo.CountryTour where LoginName='yewu1'
PNumber TMoney GNumber AddDate LoginName
1 444 22444 2013-07-19 15:51:41.000 admin
2 222 22 2013-07-19 15:51:00.000 admin
34 3434 22444 2013-07-19 16:07:21.000 admin
1 500 2013072502 2013-07-26 09:01:44.000 yewu1
1 200 22 2013-07-19 16:31:42.000 admin
PNumber TMoney GNumber AddDate LoginName
1 500 35353 2013-08-18 16:02:39.000 admin
1 666 12345 2013-07-20 22:02:15.000 admin
1 444 12345 2013-07-20 14:19:34.000 admin
1 120 1212121 2013-07-18 16:49:38.000 yewu1
1 33 1111111 2013-07-11 11:40:58.000 yewu1
1 445 12345 2013-07-19 17:00:19.000 admin
2 500 1 2013-07-11 14:14:19.000 admin
1 555 12345 2013-07-20 14:31:26.000 admin
1 666 12345 2013-07-20 14:31:48.000 admin