[thelist] reworded MySQL query insert and back again

[rudy]

> Are you being serious or have I asked something really dumb?

yes, i need to understand your table

no, you have asked nothing dumb

can you please make up the sample rows i asked?

for example, i will do the second of the three ("kumquats are small gray and
small grey") in the manner that i suspect you have designed your
relationship table --

11  210  102
11  210  101

i'll address your insert logic once i see what your table looks like

and i remain convinced that this can all be done without a temp table

be ready to ditch it, okay?   ;o)


rudy