Hi!

with nums as (
select 1 num from rdb$database
union all
select 2 num from rdb$database)
select n.num
from nums n
where not exists (select 1
from temptable t
where t.id = n.num)

András

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, November 28, 2017 11:56 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Get the value of Query Not Available In Table



Hi,

I am looking for a solution to get values in query and those not available in table data.



CREATE TABLE TEMPTABLE(

ID SMALLINT);



INSERT INTO TEMPTABLE(ID) VALUES(1);



SELECT * FROM TEMPTABLE

WHERE ID IN (1,2)



in the Above case I want to get the value 2 as output of a query.



Kindly Help.

Thanks In Advance.





__________ Information from ESET Mail Security, version of virus signature database 16483 (20171128) __________

The message was checked by ESET Mail Security.
http://www.eset.com




[Non-text portions of this message have been removed]