i need a SQL WHERE clause that gives me all rows that have a Y in any 2 of 3 possible columns.
column1 column2 column3
Y N Y = meets criteria
Y N N = not meets
i need all rows that 2 of the columns have a Y regardless of what 2 columns of the 3 columns