Hello..
First of all sorry if anyone feels i am trying to hijack this discussion No I am not.

method 1.
probably the easiest way.
1.u can do create a view, which is union of all these product tables.

2. then create a simple query which runs on this view.
remember view for u is just like a virtually existing table..

Method 2.

Use the query Build and create joins..
else
go download MySQL Maestro 8.3.bla bla bla trial and try ur idea out.
in its GUI sql query builder.
(this will work only if u have windows )

I am no expert but I believe both ways should work..