Hi

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

select count(*)
from temp
where ano=an1
ano=an2
ano=an3
ano=an4
ano=an5
Is there any alternate way where we can match One column value with all the other five coulmns

Thanks
lnr