条件查询联盟 [英] UNION OF IF CONDITION QUERIES

问题描述

& lt; HELLO ALL，
如何使如果有2个条件"查询保持一致?

例如:

IF(J = J)
开始
SELECT ID，*来自TABLE1
END

UNION

IF(I = I)
开始
SELECT ID，*来自TABLE2
END

WITH GROUPBY ID



PLS帮助....ITS URGENT

<HELLO ALL,
HOW TO MAKE UNION OF "2 IF CONDITION" QUERIES?

FOR EXAMPLE:

IF(J=J)
BEGIN
SELECT ID,* FROM TABLE1
END

UNION

IF(I=I)
BEGIN
SELECT ID,* FROM TABLE2
END

WITH GROUPBY ID



PLS HELP.... ITS URGENT

推荐答案

这可以通过使用将I和J作为参数传递的存储过程来完成.

This can be done by using a stored procedure where I and J are passed as parameters.

IF(I = I&& J == J)
开始
SELECT ID，* FROM TABLE1 UNION SELECT * FROM TABLE2 GROUP BY id
END

其他
开始

IF(J = J)
开始
SELECT ID，*来自TABLE1 GROUPBY ID
END


其他
开始
IF(I = I)
开始
SELECT ID，*来自TABLE2 GROUPBY ID
END
结束

结束


但是请确保table1和table2中包含相等数量的表达式.

IF(I=I && J==J)
BEGIN
SELECT ID,* FROM TABLE1 UNION SELECT * FROM TABLE2 GROUP BY id
END

else
begin

IF(J=J)
BEGIN
SELECT ID,* FROM TABLE1 GROUPBY ID
END


else
begin
IF(I=I)
BEGIN
SELECT ID,* FROM TABLE2 GROUPBY ID
END
end

end


But be sure that table1 and table2 have equal number of expressions in it.

如果同时需要条件和联合，则可以如下所示:


IF(J = J)然后
如果(I = I)然后
SELECT ID，*来自TABLE1
UNION
SELECT ID，*来自TABLE2
按ID分组

也就是说，您可以使用嵌套的if，然后将执行联合功能所需的两个查询联合起来.一切顺利.

If condition and union both are required then that can be done as shown below:


IF (J=J) THEN
IF (I=I) THEN
SELECT ID,* FROM TABLE1
UNION
SELECT ID,* FROM TABLE2
Group by ID

That is you can use nested if and then union those two queries required to perform union function. All the best.

这篇关于条件查询联盟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！