in reply to Re: Re: Joining Tables Problem
in thread Joining Tables Problem

That's how joins work.

You can solve this in two different ways. First, select only the items. Run a query for each item to fetch the available colors. The other option is to continue with your single query, making sure the results are returned and sorted on the item id. Push the available colors onto an array for each item id -- you'll end up with a hash of arrays of colors.

I'd go for the second solution.