ADD IN ONE TABLE ROWS FROM DIFFERENT TABLES

Goran Bibic

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted 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 table1
union all
select * from table2
union all
select * from table3
Note:- the datatype and number of columns must match in each table.
Jaydeep Patil4y ago
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