I have a SQL query pull relied on two raising columns (see below). In DB input, is it possible to set two raise columns? I am using DB Connect 3.1.4.
SELECT *
FROM table_1
WHERE (timestamp > ? AND logoff_time IS NULL) OR logoff_time> ?
ORDER BY timestamp, logoff_time
Maybe use a case in your where clause
SELECT *
FROM table_1
WHERE (case when [logoff_time] is NULL then [timestamp] else [logoff_time] end) > ?
ORDER BY timestamp, logoff_time