Hi,

I am trying to select a field with two different conditions in one SQL statement.

Some thing like this(dose not work)

select
acclst.acc_no as sacc_no, acclst.acc_no as lacc_no
from
acclst acclst
where
acclst.acc_type in(select acclst.acc_type from acclst where acclst.acc_type
= "L")and
acclst.acc_type in(select acclst.acc_type from acclst where acclst.acc_type
= "S")

If any one has suggestions please reply.

Thank you.