Be gentle please, I'm new to this forum and a baby SQL user.
I have a CASE Statement where I want to evaluate two data elements, then evaluate a combination of them, as so:
when vm.minorityowned = 1 then 'Minority'
when vm.femaleowned = 1 then 'Female'
when vm.minorityowned= 1 and vm.femaleowned = 1 then 'Minority Female'
end As 'MinorityType',
I get results back for Minority and for Female, but not for Minority Female. What's wrong with my expression? Any help appreciated. Thanks.