I have simple doubt in sql statement .
I have column from a table where column name = ANO AND ITS VALUE IS 5 ( ANO = 5) and i need to match this
column with other five columns in other table ( AN1,AN2AN3,AN4,AN5) and all these columns should have the same value
it should be like this
Is there any alternate way where we can match One column value with all the other five coulmns