I am doing a lookup on a table and matching incoming column with lookup column. If that value is not present lookup did not return that column with null. It just doesn’t return that column at all.
I need to filter the record if that value is not found it lookup table. But not able to do so. Other than joining those tables, do you have any other approach.