使用连接,如SELECT a.AID, a.AName, b.BID, b.BName, c.CID, c.CName FROM TableA a JOIN TableB b ON a.BID = b.BID JOIN TableC c ON b.CID = c.CID以上是内连接,常用的还有左外连接和右外连接等,先找本 SQL 书看看吧
select a.*,b.*,c.* from a a inner join b b on a.id = b.id inner join c c on b.id = c.id 或者 select a.* ,b.*,c* from a a ,b b, c c where a.aid = b.bid and b.id = c.cid
FROM TableA a
JOIN TableB b ON a.BID = b.BID
JOIN TableC c ON b.CID = c.CID以上是内连接,常用的还有左外连接和右外连接等,先找本 SQL 书看看吧
或者
select a.* ,b.*,c* from a a ,b b, c c where a.aid = b.bid and b.id = c.cid
就把把它做成一个视图,视图里面就试内联接查询语句