用select subject from bbs_board where postid = 70
查询出结果:11,22,33,44
postID是int字段。我想查找postid在指定的subject字段的记录
如下:
SELECT * FROM bbs_board WHERE (postID IN (select subject from bbs_board where postid = 70))
即是:
SELECT * FROM bbs_board WHERE (postID IN (11,22,33,44))请问如何实现!!!就是我用:
SELECT * FROM bbs_board WHERE (postID IN (select subject from bbs_board where postid = 70))
查询出如同
SELECT * FROM bbs_board WHERE (postID IN (11,22,33,44))的结果。。但是SELECT * FROM bbs_board WHERE (postID IN (select subject from bbs_board where postid = 70))不行
查询出结果:11,22,33,44
postID是int字段。我想查找postid在指定的subject字段的记录
如下:
SELECT * FROM bbs_board WHERE (postID IN (select subject from bbs_board where postid = 70))
即是:
SELECT * FROM bbs_board WHERE (postID IN (11,22,33,44))请问如何实现!!!就是我用:
SELECT * FROM bbs_board WHERE (postID IN (select subject from bbs_board where postid = 70))
查询出如同
SELECT * FROM bbs_board WHERE (postID IN (11,22,33,44))的结果。。但是SELECT * FROM bbs_board WHERE (postID IN (select subject from bbs_board where postid = 70))不行
SELECT * FROM bbs_board WHERE (postID IN (select cast(subject as int) from bbs_board where postid = 70))
11,22,33,44
11,22,33,44
那这样吧
declare @mysql varchar(8000)
delcare @field varchar(8000)
select @field=subject from bbs_board where postid = 70
set @mysql='select * from board where cast(postID as varchar(2)) in ('+@field+')'
exec(@mysql)