On Mar 2, 5:16 pm, "john7" <com> wrote:
What version are you using?
This looks like a structural error. Why have you got two tables
holding the same kind of data? Further, what happens if a product
belongs to more than 1 category?
That said, this is easy if you use subqueries, but just trying to do
it with joins (I think) is going to be more tricky.