SELECT spId FROM tbl_goods WHERE goodsId=2; /*2为传入的参数*/
SELECT spMemberName FROM tbl_shopInfo WHERE spId=2; /*2为第一条语句的结果*/SELECT qqNumber FROM tbl_scmember WHERE memberName='hehe';/*hehe为第二语句的结果*/如果用一条语句得到结果。
SELECT spMemberName FROM tbl_shopInfo WHERE spId=2; /*2为第一条语句的结果*/SELECT qqNumber FROM tbl_scmember WHERE memberName='hehe';/*hehe为第二语句的结果*/如果用一条语句得到结果。
FROM tbl_scmember A ,tbl_shopInfo B, tbl_goods C
WHERE C.goodsId=2 and C.spId=B.spId and B.memberName=A.memberName
inner join spMemberName b on a.goodsId=b.spId
inner join tbl_scmember c on b.spMemberName=c.memberName
where a.goodsId=2;
qqNumber
FROM tb1_goods a,spMember b,tb1_scmember c
WHERE a.goodsId=b.spId and b.spMemberName=c.memberName
and a.goodId=2;