这个视图如何创建！？（详细内容）

[woxihuanbohe]

现在有四个表
T1,T2,T3,T4
每个表里面都有一个字段id,T1有自段name,age等
现在创建一个视图把t1.id和t2,t3,t4的id相等的数据放到视图里
Create view v
select t1.id,t1.name,t1.age
from t1,t2,t3,t4
where t1.id=t2.id or t1.id=t3.id or t1.id=t4.id

这样会出现很多数据，怎么回事？大家指点下！

[pengdali]

Create view v as
select t1.id,t1.name,t1.age,t2.列,t3.列,t4.列
from t1,t2,t3,t4
where t1.id=t2.id and t1.id=t3.id and t1.id=t4.id

[loverforever]

CREATE VIEW V
AS
SELECT T1.ID,T1.NAME,T1.AGE
FROM T1,T2,T3,T4
WHERE T1.ID=T2.ID AND T1.ID=T3.ID AND T1.ID=T4.ID

[txlicenhe]

Create view v
select t1.id,t1.name,t1.age
from t1,t2,t3,t4
where t1.id=t2.id or t1.id=t3.id or t1.id=t4.id
只要有相等的就查出来

Create view v as
select t1.id,t1.name,t1.age
from t1,t2,t3,t4
where t1.id=t2.id and t1.id=t3.id and t1.id=t4.id
全相等的才查出来

[caiyunxia]

--where t1.id=t2.id and t1.id=t3.id and t1.id=t4.id

[yangvxin1]

Create view v as

select * from t1
where id in(select id from t2 union select id from t3 union select id from t4)

[sdhdy]

--t1表的3个列，和t2,t3,t4的非id列列出来
Create view vw_test as
select t1.id,t1.name,t1.age,t2.列1,t2.列2,t3.列1,t3.列2,t4.列1,t4.列2
from t1,t2,t3,t4
where t1.id=t2.id and t1.id=t3.id and t1.id=t4.id

[zjcxc]

即然你是将所有表id相同的记录都查出来,条件就该用and,否则就会形成多对多的关系.当然会出现很多记录了.

Create view v
select t1.id,t1.name,t1.age
from t1,t2,t3,t4
where t1.id=t2.id and t1.id=t3.id and t1.id=t4.id

[woxihuanbohe]

谢谢我后面的几位前辈指点。我数据库理论没学好，写的代码太长了！

问题已经解决，谢谢各位的支持！

[woxihuanbohe]

多谢大家的技术支持，我要的答案是这样子的！


SELECT img_id, img_length, img_data
FROM dbo.Tab_img
WHERE (img_id IN
(SELECT d.id
FROM d, tab_img i
WHERE d.id = i.img_id)) OR
(img_id IN
(SELECT h.id
FROM h, tab_img im
WHERE h.id = im.img_id)) OR
(img_id IN
(SELECT p.id
FROM p, tab_img img
WHERE p.id = img.img_id)) OR
(img_id IN
(SELECT r.id
FROM r, tab_img ii
WHERE r.id = ii.img_id))

[愉快的登山者]

SELECT img_id, img_length, img_data
FROM dbo.Tab_img
WHERE img_id IN
(SELECT d.id FROM d
union SELECT h.id FROM h
union SELECT p.id FROM p
union SELECT r.id FROM r)

[zjcxc]

SELECT img_id, img_length, img_data
FROM dbo.Tab_img
WHERE img_id IN
(SELECT id from d union select id from h union select id from union select id from r)

[CrazyFor]

SELECT img_id, img_length, img_data
FROM dbo.Tab_img
WHERE img_id IN
(SELECT d.id FROM d
union
SELECT h.id FROM h
union
SELECT p.id FROM p
union
SELECT r.id FROM r)