ADD IN ONE TABLE ROWS FROM DIFFERENT TABLES

Question

NEED TO CREATE NORMATIVE FOR PRODUCTION
I HAVE PEACES: tbl.pieces
1. D1234
2. C1234

FOR PIECE 1 NEED MATERIAL: tbl.normativo
1. TUBE
2. SHEET METAL

FOR PIECE 2 NEED MATERIAL:tbl.normativo
2.BAR

Result in final table (DATAGRID) need to be

1. D1234
    1. TUBE
    2. SHEET METAL
2. C1234
    1. BAR

I TRY TO UNDERSTAND LOGIC OF MS SQL

SELECT FROM dbo.pieces

Result:
id  drawing_name
1.    D1234
2.    C1234

Select * from dbo.normativo

Result:
Nr  Material       drawing
1. TUBE            D1234
2. SHEET METAL     D1234
1. BAR             C1234

Sachin Singh · Answer

You have multiple solutions better one :- Join SELECT * FROM dbo.pieces p JOIN dbo . normativo n on p.drawing_name=n.drawing if Join is not an option then union/union all You can simply use union or union all select * from table 1 union all select * from table 2 union all select * from table 3 Note:- the datatype and number of columns must match in each table.

Jaydeep Patil · Answer

Hi Goran Check the following link that might help you to insert bulk data using union all from one table to another you need to write an actual data select query rather than some static data as shown in the below link you replace your select query over there and also provide proper no of column and name in the insert section of the target table. https://www.c-sharpcorner.com/blogs/insert-records-using-select-and-union-all-statements-in-sql1 Regards Jaydeep Patil