> > ... because size is returning more then one result, because the > > sizes for this product is more then one. what i got back was > > the product listed 9 times, one for each size in the product. If you know what size you want, add it to your WHERE clause. If you don't, what do you want the query to do? -- Ed McCarroll (310) 838-4330 Ed at ComSimplicity.com http://www.ComSimplicity.com