Select SQL

[Nolik]

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.

[bsmith]

I dont't think you can do what you are trying to do. You can create a stored procedure to return a recordset based on the acc_type. The execute the stored procedure twice once when acc_type = "L" and once when acc_type = "S". Or you can select acc_no and acc_type and loop through the recordset and process on the acc_type. It depends on what you are trying to do with the select.

[Clunietp]

Why don't you do this?

select
acclst.acc_no as sacc_no, acclst.acc_no as lacc_no
from
acclst acclst
where
acclst.acc_type = "L" OR
acclst.acc_type = "S"

[JHausmann]

Use Tom's SQL. Yours doesn't work because your query expects one field to have two values/record. acclst.acc_type cannot be "L" and "S", at the same time.

[Nolik]

Use Tom's SQL. Yours doesn't work because your query expects one field to have two values/record. acclst.acc_type cannot be "L" and "S", at the same time.

[Clunietp]

Sorry! I am TOM. This is my code.


Why don't you do this?

select
acclst.acc_no as sacc_no, acclst.acc_no as lacc_no
from
acclst acclst
where
acclst.acc_type = "L" OR
acclst.acc_type = "S"

[JHausmann]

Suppose I should've said Clunietp. :)