I am not a programmer, well I know action script so here's my best attempt to explain what I need.
I have 3 tables with different data.
Table 1 is 'products' and has 'id' and 'name' columns
Table 2 is 'safety_documents' and has 'id' and 'title' columns
Table 3 is 'product_documents' and has 'product_id' and 'document_id' columns
I need to find and replace Table 1 'id' with Table 2 'title'
There is more than 1 product_id with the same value, meaning 1 product_id can have 0 up to 7 document_ids
Ideally I need to create a new table that has:
product_id, product_name, document_title 1, document title 2,...document title X
Any help is appreciated