RelationQQID,NickName,Age, 这三个数据来自三个表 怎样查询到
SELECT RelationQQID,NickName,Age
FROM QQUser AS u AND BaseInfo AS bi
JOIN Relation AS r
ON u.QQID=bi.QQID=r.QQID
WHERE QQID=88662753 AND RelationStatus=0;
RelationQQID,NickName,Age, 这三个数据来自三个表 怎样查询到
SELECT RelationQQID,NickName,Age
FROM QQUser AS u AND BaseInfo AS bi
JOIN Relation AS r
ON u.QQID=bi.QQID=r.QQID
WHERE QQID=88662753 AND RelationStatus=0;
SELECT RelationQQID,NickName,Age
FROM QQUser u ,BaseInfo bi ,Relation r
where u.QQID=bi.QQID and bi.QQID=r.QQID
and u.QQID=88662753 AND RelationStatus=0;