34,838
社区成员




SQL codeSQL codeSELECT Buy.ID,Buy.Title,Buy.SmallClassID,
shi.shiName,qu.quName,SmallClass.SmallClassName
FROM Buy,Shi,Qu, SmallClass
WHERE Buy.SmallClassID=68 and Buy.shi=1 and Buy.IsCheck=1
and Buy.shi=shi.ID AND Buy.qu=qu.ID AND Buy.SmallClassID=SmallClass.ID
SELECT Buy.ID,Buy.Title,Buy.SmallClassID,shi.shiName,qu.quName,SmallClass.SmallClassName
FROM Buy join shi on Buy.shi=shi.ID join qu on Buy.qu=qu.ID
join SmallClass on Buy.SmallClassID=SmallClass.ID
where buy.SmallClassID=68 and buy.shi=1 and buy.IsCheck=1