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.