Hello-
I have an owners table where they have a list of 3 different companies in 3 columns (cnumber, cnumber2, cnumber3). I want my query to search on all 3 columns to find the match for the company they logged in under. How can I do this? So example would be:
I have an owners table where they have a list of 3 different companies in 3 columns (cnumber, cnumber2, cnumber3). I want my query to search on all 3 columns to find the match for the company they logged in under. How can I do this? So example would be:
Code:
Select * from owners where cnumber, cnumber2 or cnumber3 = companyID