Hello All,
I have the below Logic Already existing in a Calculation View:
Select A,B,C from table 1 UNION Select A,B,C from table 2;
Now i want to convert the above logic to below scenario, in case if First select statement succeeds in fetching data then second Select statement data should not be considered. Only when there is no data at first Select statement we need fetch the data from second Select Statement.
Kindly help me with our inputs for this requirement.
Thanks in Advance!