Unnamed

-- try something like:SELECT i.sku, tov.valueFROM	type_option_values tov,	type_options to,	items iWHERE tov.value = 'garden_flowers'AND to.option_name = 'unit_color'AND tov.option_id = to.option_idAND i.sku = tov.sku;-- it would be more helpful to have the output of SHOW CREATE TABLE... available so we could copy-and-paste and test it live in mysql-- Love, pizza