I have a table with patient records. There is one column with primary diagnose and 20 columns with secondary diagnoses.
I often receive order to get a list of patients with this and that diagnose regardless primary or secondary. For now I use query for each diagnose column combined by "OR".
My question is if there is more elegant way to query?
Looking forward to hearing from you.