create view.txt

部分功能：1.查询旅游信息：主要查询景点和酒店的信息

CREATE VIEW JingDian_JiuDian AS
	SELECT 
		JingDian.BianHao AS JingDianBianHao,
		JiuDian.BianHao AS JiuDianBianHao,
		JingDian.MingCheng AS JingDianMingCheng,
		JiuDian.MingCheng AS JiuDianMingCheng
	FROM 
		JingDian,SheZhi,JiuDian
	WHERE 
		JingDian.BianHao=SheZhi.JingDianBianHao 
			AND
		SheZhi.JiuDianBianHao = JiuDian.BianHao


CREATE VIEW JingDian_LVXingShe AS
	SELECT
		JingDian.BianHao AS JingDianBianHao,
		LVXingShe.BianHao AS LVXingSheBianHao,
		JingDian.MingCheng AS JingDianMingCheng,
		LVXingShe.MingCheng AS LVXingSheMingCheng
	FROM
		JingDian,FuZe,LVXingShe
	WHERE
		JingDian.BianHao=FuZe.JingDianBianHao
			AND
		FuZe.LVXingSheBianHao = LVXingShe.BianHao



CREATE VIEW YuDing_JiuDian AS SELECT YuDingJiuDian.YongHu,JiuDian.BianHao,JiuDian.MingCheng FROM YuDingJiuDian,JiuDian WHERE YuDingJiuDian.JiuDianBianHao=JiuDian.BianHao