I get empty rows as shown below due to outer join and that record is not available in DB.
Table1 table2 table3
1 cat cow
2 monkey
I am get empty data in table2 / table2 since the data is not available and want to apply the formula on the data base field to check if the field = empty and display "No Data" .But when i apply formula in the data base field,
its not allowing and says that you have to return boolean field.
Can any one tell me how to apply formula in the data base field that has empty value not sure it could be null also since outer join the data is not there . the outer join just shows the empty value.
Table1 table2 table3
1 cat cow
2 monkey
I am get empty data in table2 / table2 since the data is not available and want to apply the formula on the data base field to check if the field = empty and display "No Data" .But when i apply formula in the data base field,
its not allowing and says that you have to return boolean field.
Can any one tell me how to apply formula in the data base field that has empty value not sure it could be null also since outer join the data is not there . the outer join just shows the empty value.