hi all,
I have a SQL which has a simple join as below
select B.PRODUCT FROM TABLEA A
JOIN TABLEB B
ON A."Key" = B."Key"
I need to extend this query such that if current month is January , then I need to skip join and return hardcoded value as "default product" and if it is not January then I need to return the values using join in the above SQL .
Is it possible to do this in the above SQL query itself .
Thanks