On Thu, Jan 22, 2009 at 11:37 AM, Jason Morris <[email protected]> wrote: > SELECT INVHH.HH_ORD, INVHH.HH_NME,MNBDD.BD_GLSA FROM INVHH > JOIN MNBDD ON MNBDD.BD_TID = INVHH.HH_TID > WHERE MNBDD.BD_GLSA IN (here's my problem)
Not sure (my SQL is weak), but a "GROUP BY BD_GLSA" clause may get you closer to what you want. To count each one, I think "COUNT DISTINCT (BD_GLSA)" in the FROM clause field list will help. I'm not sure you can combine the two, though. -- Ben ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
