可以.
select TeacherID as UserID,Email from Teacher
union all
select StudentID, Email from Student
select TeacherID as UserID,Email from Teacher
union all
select StudentID, Email from Student
解决方案 »
- 执行SQL语句后,警告: 聚合或其他 SET 操作消除了空值。
- 我的存储过程有错误,是怎么回事!
- SQL-SERVER的数据同步可以在2台SQL-SERVER之间同步数据,那有什么方法可以在ACCESS和SQL-SERVER之间同步数据呢?我想把SQL-SERVER的数据同
- 一个基础问题!
- [help]一个求最大值的sql
- SQL求数据统计问题
- 请问SQL事务回滚如何用?请给出语法及示例
- 超级变态的门禁考勤系统的查询
- 这是怎么回事呀?急,java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]无效的描述符索引
- OA中的查询实现?
- 初学问题,高分求教!!!!
- 遇到有SQL语句的ASP页,就出错!为什么?
FROM TeacherUNIONSELECT StudentID ,Email
FROM Student
Insert into UserTable(UserId,Email)
Select * from Teacher
Union
Select * from Student
2、
Select * from UserTable
如果你的TeacherID 與studentID 都是如1,2,3 ...這樣的值,有時為了更清晰點,可在前加上前綴,這樣id不會的重復值可將union後的all去掉
select 'T'+TeacherID as ID ,Email union select 'S'+studentID as ID ,Email
union all select 'S'+studentID as ID ,Email from Student
Union
Select * from Student
可排除TeacherID,StudentID重复的可能如果要根据给出的在两张表里同时查找可用:
SELECT Userid=TeacherID as UserID,Email
FROM Teacher
UNION
SELECT Userid=StudentID ,Email
FROM Student