Please help me

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;

BarcodePalletGrossWtQty
702171132900
70717917757599
70718316752599
7071959752599

SELECT * FROM YARN_FPDT_out;

BarcodePalletGrossWtQty
702111132900
702123132400
20705611765725
2070653665620
20707713648603
2070815752599

and question is

please create one another table like yarn_fpdt_result and display the result like this

BarcodePalletGrossWtQty
7021331322200
20705611765725
2070653665620
20707713648603
2070815752599
70717917757599
70718316752599
7071959752599

ok

its very urgent plz help me

Quote:

Originally Posted by 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;

BarcodePalletGrossWtQty
702171132900
70717917757599
70718316752599
7071959752599

SELECT * FROM YARN_FPDT_out;

BarcodePalletGrossWtQty
702111132900
702123132400
20705611765725
2070653665620
20707713648603
2070815752599

and question is

please create one another table like yarn_fpdt_result and display the result like this

BarcodePalletGrossWtQty
7021331322200
20705611765725
2070653665620
20707713648603
2070815752599
70717917757599
70718316752599
7071959752599

ok

its very urgent plz help me

Use UNION

Select * from YARN_FPDT_IN
UNION
Select * from YARN_FPDT_out|||As you have posted a question in the Article section it is being moved to SQL Server Forum

MODERATOR