Printable View
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.
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.
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"
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.
Quote:
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.
Sorry! I am TOM. This is my code.
Quote:
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"
Suppose I should've said Clunietp. :)