试试
Select A.aid,A.Name,Min(width) As width
from A
Inner Join B On A.aid=B.aid
Left Join C On B.cid=C.Cid
Select A.aid,A.Name,Min(width) As width
from A
Inner Join B On A.aid=B.aid
Left Join C On B.cid=C.Cid
调试欢乐多
在此为何要加group by语句?
还有,如果要取对应c表的多个字段呢?
from A
Inner Join B On A.aid=B.aid
Left Join C On B.cid=C.Cid
Group By A.aid,A.Name
如果要对应多个,处理更简单
Select A.aid,A.Name,width
from A
Inner Join B On A.aid=B.aid
Left Join C On B.cid=C.Cid