Inserting product variants

[kpowning]

How can I write a script that will check (xcart_class_options against xcart_variants) to get all the different variants listed in (xcart_variant_items)? I would really appreciate any advise. PLEASE

Thanks

[djjjozsi]

i don't really like images, can you just copy the table names and field names as text here? 🙂 and i'm on a tutorial now how to build a query with three tables.
comma delimitered list is the best wy you can do that.
values aren't important.
hy,
jjozsi

an addition:
try this query in phpmyadmin:

SELECT *
FROM xcart_variants LEFT JOIN (xcart_variant_items LEFT JOIN xcart_class_options ON xcart_variant_items.optionid=xcart_class_options.optionid) ON xcart_variants.variantid=xcart_variant_items.variantid;