with the values of those fields defined in s01_CFM_ProdValues.
s01_Products is much like you'd expect, typical product table with a uniqe id and some universal product details (name, description, price, cost, etc). I'll give examples of the other two tables so that you can get a better idea of how the extra fields work:
Example of s01_CFM_ProdFields:
Code: Select all
id code name
1 MFCD Manufacturer Code
2 MFNM Brand
3 MFSKU SKU
4 MFUPC UPC
5 COLOR ColorCode: Select all
field_id product_id value
2 8145 Acme
5 8145 Blue
2 8197 TimCoNow, for the fun part. What I'd really like is a view that has all of the extra fields joined onto the s01_Products table as if they were normal everyday columns. I don't even know if this is possible. Basically, it's defining each extra column as if it were...
Code: Select all
SELECT `value`
FROM `s01_CFM_ProdValues`
WHERE `field_id` = 8
AND `product_id` = this_row_product_idAny help would be greatly, greatly appreciated