Please help me

[asvinalbert]

i have 2 tables like yarn_fpdt_in and yarn_fpdt_out the yarn_fpdt_in contain barcode,pallet, qty and yarn_fpdt_out contain same like 1st table like following

SELECT * FROM YARN_FPDT_IN;

Barcode Pallet GrossWt Qty
7021 7 1132 900
707179 17 757 599
707183 16 752 599
707195 9 752 599

SELECT * FROM YARN_FPDT_out;

Barcode Pallet GrossWt Qty
7021 1 1132 900
7021 2 3132 400
207056 11 765 725
207065 3 665 620
207077 13 648 603
207081 5 752 599


and question is

please create one another table like yarn_fpdt_resul t and display the result like this

Barcode Pallet GrossWt Qty
7021 3 3132 2200
207056 11 765 725
207065 3 665 620
207077 13 648 603
207081 5 752 599
707179 17 757 599
707183 16 752 599
707195 9 752 599


ok


its very urgent plz help me

[Vidhura]

i have 2 tables like yarn_fpdt_in and yarn_fpdt_out the yarn_fpdt_in contain barcode,pallet, qty and yarn_fpdt_out contain same like 1st table like following

SELECT * FROM YARN_FPDT_IN;

Barcode Pallet GrossWt Qty
7021 7 1132 900
707179 17 757 599
707183 16 752 599
707195 9 752 599

SELECT * FROM YARN_FPDT_out;

Barcode Pallet GrossWt Qty
7021 1 1132 900
7021 2 3132 400
207056 11 765 725
207065 3 665 620
207077 13 648 603
207081 5 752 599


and question is

please create one another table like yarn_fpdt_resul t and display the result like this

Barcode Pallet GrossWt Qty
7021 3 3132 2200
207056 11 765 725
207065 3 665 620
207077 13 648 603
207081 5 752 599
707179 17 757 599
707183 16 752 599
707195 9 752 599


ok


its very urgent plz help me

Use UNION

Select * from YARN_FPDT_IN
UNION
Select * from YARN_FPDT_out

[debasisdas]

As you have posted a question in the Article section it is being moved to SQL Server Forum

MODERATOR