Hello everyone i have this problem
i have a table like this
id sequence phase characteristics
1 1 300 001
2 1 300 001
2 2 300 002
..
and another table that contain a lot of characteristics for each phase
phase characteristics
300 003
300 004
300 005
....
i need to add all the characteristics to each id/sequence where phase is 300
for better understanding what i need is
id sequence phase characteristics
1 1 300 001
1 1 300 003
1 1 300 004
1 1 300 005
2 1 300 001
2 1 300 003
2 1 300 004
2 1 300 005
2 2 300 002
2 2 300 003
2 2 300 004
2 2 300 005
..
I have attempted several solutions, but I am not proficient in SQL. Could someone please offer assistance? Thank you in advance
New contributor
Emanuele Pina is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.