想要另一个解决方案来触发查询 [英] Want another solution to fire the query

问题描述

你好朋友，

我下面的查询工作正常..

Hello friends,

my below query is working well..

SELECT chln_prefix,chln_no
FROM PC
except
SELECT prefix,doc_no
FROM PB

但我想触发这样的下面的查询.如何使用noting代替noting?
请帮帮我.

but I want to fire such below query. How can I use noting in place of except?
Please help me.

SELECT chln_prefix,chln_no,chln_name
FROM PC
except
SELECT prefix,doc_no
FROM PB

谢谢

推荐答案

您有几种选择，但是最快的方法可能只是使用一个虚拟值:

You have a few options, but the quickest is probably to just use a dummy value:

    SELECT chln_prefix,chln_no,chln_name
    FROM PC
EXCEPT
    SELECT prefix,doc_no, 0 AS DummyValue
    FROM PB

这篇关于想要另一个解决方案来触发查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！