>Either chenge the order of "ON..." clauses so :
>ON ONHND.PARTNO=MASTER.PARTNO;
>ON MASTER.GROUP=GROUP.GABBR;
>
>Or :
>FROM GROUP RIGHT OUTER JOIN MASTER ;
>ON MASTER.GROUP=GROUP.GABBR;
>INNER JOIN ONHND;
>ON ONHND.PARTNO=MASTER.PARTNO;
>
>Otherwise you'd get that "forever" join. Take a look at how 4 tables in testdata.dbc (home()+"samples\data") are connected in a view.
>Cetin

THANKS!! Microsoft's documentation of SELECT - SQL is soooo sparce on examples I wasn't sure what was legal syntax and what wasn't:) Thanks for your help