Here is my situation: I have a query that is somewhat straightforward except for one clause. there are 2 columns (for arguments sake lets call these columns 'abc' and 'efg') which do not exist in any table in my database. The requester would still like to see this the columns in the query but the rows for the columns should contain null values.
I tried using this approach:
select column_1, 'abc', 'efg'