志愿者表：
--1.建立志愿者表
Create table volunteer
(stu_id varchar(10),
Stu_name varchar(10),
Stu_major varchar(10) ,
Stu_iphone varchar(10)
Primary key(stu_id));
--1.1向志愿者表插入資料
Insert into volunteer values
('1','張三','信管1','111'),
('2','李四','信管1','222'),
('3','王五','信管1','333'),
('4','鄭杰','信管1','444'),
('5','黎麟','信管1','555'),
('6','森','信管1','666'),
('7','陳宏','信管1','777'),
('8','張森','信管2','888'),
('9','逵','信管2','999'),
('10','張','信管2','1010');
insert into volunteer values('11','白起','信管2','1111');
活動表：
--2.建立活動表
Create table activity(
act_id varchar(10),
Act_name varchar(10),
Act_time varchar(10),
Act_place varchar(10),
Act_capacity varchar(10)
Primary key(act_id)
);
--2.1向活動表中插入資料
Insert into activity values
('001','善行一百','10.1','郵政大廈','100'),
('002','長南逕','11.1','普陀寺','50'),
('003','撿垃圾','12.1','明德樓','100'),
('004','扶單車','05.1','三飯','100'),
('005','掃地','09.1','弘毅樓','100'),
('006','維持交通','05.1','天佑樓','50'),
('007','清理課桌','04.1','精工樓','100'),
('008','整理檔案','03.1','行政樓','90'),
('009','維護設施','02.25','體育館','100'),
('010','清理操場','01.01','操場','50');
報名表：
--3.建立報名表
Create table sign(
Stu_id varchar(10),
Act_id varchar (10),
Sign_time varchar(10),
Stu_name varchar(10),
Act_name varchar(10),
Star_check_time varchar(50),
End_check_time varchar(50),
Primary key(stu_id,act_id)
);
--洗掉報名表
drop table sign ;
--3.1向報名表插入資料
Insert into sign values
('1','001','9.25','張三','善行一百','10.1/10.1','12.1/10.1'),
('2','002','10.10','李四','長南逕','11.1/8.00','11/1/11.00'),
('3','003','11.22','王五','撿垃圾','12/1/8.00','12/1/12.00'),
('4','004','9.25','鄭世杰','扶單車','05.1/10.00','05.1/12.00'),
('5','005','10.10','黎展麟','掃地','09.1/8.00','09.1/11.00'),
('6','006','11.22','溫柳森','維持交通','05.1/8.00','05.1/12.00'),
('7','007','9.25','陳振宏','清理課桌','04.1/10.00','04.1/12.00'),
('8','008','10.10','張海森','整理檔案','03.1/8.00','03.1/11.00'),
('9','009','11.22','周鴻逵','維護設施','02.25/8.00','02.25/12.00'),
('10','010','12.22','張國威','清理操場','01.01/8.00','01.01/10.00');
出現問題的代碼：
--3.8創建志愿者報名成功的視圖
create view f
as
select Stu.id,Act_id,Act_name
from volunteer,sign
where volunteer.Stu_id=sign.Stu_id;
我想volunteer和sigh兩個表通過Stu_id進行匹對，在出現在sign表里面的volunteer的資訊顯示，但是sql提示無法系結由多個部分組成的識別符號 "Stu.id"。
uj5u.com熱心網友回復：
create view fas
select Stu.id,Act_id,Act_name
select volunteer.Stu_id,Act_id,Act_name
select sign.Stu_id,Act_id,Act_name
from volunteer,sign
where volunteer.Stu_id=sign.Stu_id;
換成紅字中任何一行
uj5u.com熱心網友回復：
謝謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/26163.html
標籤：基礎類