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.