5 lines
208 B
SQL
Executable File
5 lines
208 B
SQL
Executable File
create view idm_user
|
|
as
|
|
(SELECT nachname, vorname, uid, pwd, mail,'S' art from kurs.stud where durchgefallen != 'Y')
|
|
union
|
|
(select doz_name, doz_vorname, doz_uid, doz_pwd, doz_mail, 'D' art from kurs.doz) |