SELECT C.clientID, C.Name, B.name as Bname, A.name as Aname FROM client as C, country as B, province as A WHERE and C.countryID = B.countryID and C.provinceID = A.provinceID 把你的查询语句换成这个试试看。
上面的写错了,多打了个and。试下面的:SELECT C.clientID, C.Name, B.name as Bname, A.name as Aname FROM client as C, country as B, province as A WHERE C.countryID = B.countryID and C.provinceID = A.provinceID
FROM client as C, country as B, province as A
WHERE and C.countryID = B.countryID and C.provinceID = A.provinceID 把你的查询语句换成这个试试看。
FROM client as C, country as B, province as A
WHERE C.countryID = B.countryID and C.provinceID = A.provinceID