Select in SQL

[Arnold]

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.

[Tahir]

Hi,

If your tables are same like in your example then its very easy as you can
write like
where
acclst.acc_type in(select acclst.acc_type from acclst where acclst.acc_type
>= "L" and/or acclst.acc_type >= "W")

But, if your condition tables are different then perhaps you can write something
like

where
acclst.acc_type in(select acclst.acc_type from acclst where acclst.acc_type
>= "L" UNION
select acclst.acc_type from acclst where acclst.acc_type >= "W")

Hope this helps.




"Arnold" <nolik1@excite.com> wrote:
>
>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.