Re: SQL question with subselect

>select vendor, vndnam, vndad1, vndad2, vndad3, vstate, vpost, vdtlpd from
>bpcsf/avm where vendor in (select abvnd, count(*) from bpcsf/abr where
>absts <> 'W' group by abvnd) order by vendor

Dennis,

you are asking to "select from bpcsf where vendor in (subselect)"

(subselect) must resolve to a list of vendors, yet you are listing two
fields in the subselect - vendor and count.

what is the reason for the count?  from your statement, i don't see a use
for it, so get rid of it.

hth,

Rick