1
I have a table called products, this table already has the fields necessary for its use, but now I need to include 4 more (four) columns in it, columns that will be the description of some ID s I have, the table structure is currently like this:
IdProduto | IdDepto | IdSubDepto | Idmarca | IdModelo | Codigo | DescProd | Tamanho | largura
Now I need to insert the description of each ID s in this table keeping the existing fields, it should look like this:
IdProduto | IdDepto | DescDepto | IdSubDepto | DescSubDepto | Idmarca | Descmarca | IdModelo | DescModelo | Codigo | DescProd | Tamanho | largura
The columns to be inserted are: Descdepto, Descsubdepto, Descmarca and Descmodelo
I couldn’t envision a possibility that could help me solve this problem.
Are these new columns to keep a track of the last description? make a view with a Jay picking the description wouldn’t solve?
– rray
Hello @rray, the new columns should keep the description of the ID, I never made a view, but I will give a search, thanks for the tip.
– adventistapr