SELECT ONHND.FPARTNO, MASTER.FDESCRIPT, ONHND.TOTONHAND, MASTER.FGROUP, GROUP.GNAME; FROM GROUP RIGHT OUTER JOIN MASTER INNER JOIN ONHND; ON MASTER.GROUP=GROUP.GABBR; ON ONHND.PARTNO=MASTER.PARTNO; WHERE MASTER.GROUP=="C""C" is abbreviation for "CURRENT"...this is in the Group table and works fine if I inner join the MASTER and GROUP on Group=gabbr; but when I do the above and try to include stuff from ONHND, like TOTalONHAND, then the SELECT takes FOREVER!! If I undo the Join between GROUP and MASTER, then my WHERE clause doesn't work....