Re: SQL question with subselect

[rick.baird@xxxxxxxxxxxxxxx]

I should read the entire message before answering :(

>In a group by situation in a sub query, it seems that I can have only one
>column selected.  Obviously without the count by vendor, the report is
>useless so how do I get that count & vendor number?

something like this:

select distinct vendor,
    max(vndnam), max(vndad1),
    max(vndad2), max(vndad3),
    max(vstate), max(vpost),
    max(vdtlpd), count(abvnd)
from bpcsf/avm
join bpcsf/abr
on vendor = abvnd
group by abvnd