sql where条件动态生成

[shuxiang0411]

sql的where条件在数据库条件表中取（A表）

A表(条件表)
condition1 condition2
A3 001
A4 002
A3 002

sql 应该是 select * from B where （h='A3' and C='001') OR （h='A4' and C='002') OR （h='A3' and C='002')
A表条数不确定 怎么生成sql的where条件

[还在加载中灬]

DECLARE @SQL VARCHAR(8000)
SET @SQL=''
SELECT @SQL=@SQL+'OR(h='''+condition1+''' AND C='''+condition2+''')' FROM A
IF LEN(@SQL)>0
	SET @SQL='WHERE '+STUFF(@SQL,1,2,'')
ELSE
	SET @SQL=''
SET @SQL='SELECT * FROM B '+@SQL
PRINT @SQL

[zhll2046]

一个exists相关子查询 就OK了. http://msdn.microsoft.com/zh-cn/library/ms188336.aspx

CREATE TABLE A (condition1 varchar(99),condition2 varchar(99));
INSERT INTO A VALUES('A3','001'),('A4','002'),('A5','003');

CREATE TABLE B (h varchar(99),c varchar(99));
INSERT INTO B VALUES('A3','001'),('A4','004'),('A5','003');

SELECT * FROM B WHERE EXISTS(SELECT * FROM A WHERE A.condition1=B.h AND A.condition2=B.c)

DROP TABLE A;
DROP TABLE B;