December 12, 2019 at 7:32 am
Hello everyone
I have on each table of my base two columns used to store my anomalies Functional [error_id] and [description_error]
create table produit
(
id int ,
nom varchar(50),
id_erreur int ,
description_erreur varchar(50),
)
create table magazin
(
id int ,
nom varchar(50),
id_erreur int ,
description_erreur varchar(50),
)
I would like to store all my errors with their descriptions with the name of the source table in a single reference table by going through all the error_id the table reference error is the following
create table list_erreur
(nom_table varchar(50),
id_erreur int ,
descritption varchar(50)
)
Who has an idea please
Thank you for your return
December 12, 2019 at 9:31 am
John
December 12, 2019 at 12:37 pm
Instead of providing us with a list of requirements and forcing us to play "guess the question", why not ask us something specific?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
December 12, 2019 at 3:05 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply