a :id1,name1 sex ;b:id2,name2,old ;c:id3,name3,studey
现在语句是这样的
select a.id1,a.name1,a.sex ,b.id2,b.name2,b.old,c.id3,c.name3 from a,b,c where
a.id1=b.id2and b.id2=c.id3 and a.name1=b.name2 and b.name2=c.name3怎么调试都不行啊??拜托急
现在语句是这样的
select a.id1,a.name1,a.sex ,b.id2,b.name2,b.old,c.id3,c.name3 from a,b,c where
a.id1=b.id2and b.id2=c.id3 and a.name1=b.name2 and b.name2=c.name3怎么调试都不行啊??拜托急
a.id1=b.id2 and b.id2=c.id3 and a.name1=b.name2 and b.name2=c.name3语法正确的,你可能需要left join
首先要看看你主要從哪個表取資料,假設你是要從c 表中取得所有資料,
然後根據c表中的c.name3=b.name and c.id3=b.id2取出b表相應字段
c.name3=a.name1 and c.id3=a.id1取出a表中相應字段那語句這麼寫
select a.id1,a.name1,a.sex ,b.id2,b.name2,b.old,c.id3,c.name3
from c
left join a on a.name1=c.name3 and a.id1=c.id3
left join b on b.name2=c.name3 and b.id2=c.id3
the following is SQL Server
select a.id1,
a.name1,
a.sex ,
b.id2,
b.name2,
b.old,
c.id3,
c.name3
from a,b,c
where a.id1 *= b.id2
and a.id1 *=c.id3 --b.id2 *= c.id3 is ok too, but I think a is the main table
and a.name1 *= b.name2
and a.name1 *= c.name3 --b.name2 *= c.name3 is ok too