多表查询

SELECT   g.name,
              m.name,
              m.phone,
              m.mobile
    FROM   Appuser   as   u,
              linkgroup   AS   g,
              linkman   as   m
  WHERE   u.username   =   'zealot '
        &&   u.ID   =   g.userid
        &&   g.ID   =   m.GID
        &&   (       m.phone   like   '%139% '
                ||   m.mobile   like   '%139% '
              );

 

SELECT A.AGENTID, A.Mname, A.BriefInfo
FROM
AGENT AS A
INNER JOIN TBSupplierProperty as t
INNER JOIN [WholesalerProperty] AS W
ON A.AGENTID=T.AGENTID A.AGENTID=W.AGNTID
WEHRE 1=1 AND T.IsSellOne=1 AND T.Fee=1 AND
T.IsSellOne=1

select top 10
a.agentid,
a.CateId,
d.AdInfoName,
d.AdImageAdress,
d.AdLinkAdress
from [ads] as d  INNER JOIN [agent] as a
on   d.AgentId=a.AgentId

select  * from [ADs]