34,873
社区成员
发帖
与我相关
我的任务
分享大家帮帮忙，在同一个表连着查两次，怎么写！在线等...
sql=select * from product where classID in (select ID from class where upClassID = (select ID from class and upClassID="&sortID2&"))"
...全文
请发表友善的回复…
发表回复
QCB181 2004-04-07
- 打赏
- 举报
sql=select * from product where classID in (select ID from class where upClassID = (select ID from class and upClassID="&sortID1&"))
是我自己写错了，现在可以了！
是我自己写错了，现在可以了！
gechaosa 2004-04-07
- 打赏
- 举报
select * from product where classID in (select ID from class where upClassID = id and )upClassID="&sortID2&"
gechaosa 2004-04-07
- 打赏
- 举报
select * from product where classID in (select ID from class where upClassID = id and upClassID="&sortID2&"
gechaosa 2004-04-07
- 打赏
- 举报
select * from product where classID in (select ID from class where upClassID = (select ID from class) and upClassID="&sortID2&"
