SQL创建表问题求助
# 创建预定表create table RESERVATIONS(
resvNum varchar(5) not null,
custID varchar(5) not null,
resvType int check(resvType in (1, 2, 3)),
resvKey varchar(5) check(resvKey in (select flightNumfrom FLIGHTS union all select HOTELS.hotelNumfrom HOTELS union all select BUS.busNumfrom BUS)),
primary key(resvNum));
求助，请问哪里出错了？
页:
[1]