I have this table with a column name “InformationType”. Now based on the value of the informationType, I want to run another query.

Let’s say if informationType = ‘abc’ then look for rows with informationType = ‘xyz’ too and data of both the information types should be clubbed together (like a Union does).

So, if there is 1 row present with ‘abc’ informationType and 1 row with ‘xyz’ then returned resultset should be total 2 rows.

AND,

If informationType is not ‘abc’ then don’t look further for ‘xyz’ informationType and return null. i.e 0 rows

Can it be achieved using a query? I cannot use PL/SQL.