i want to insert two table data and then show both table dat

Question

i am using two insert query to add two table data instead of insert with select clause and it works but not save data together. then i am using this query to show data in datatable gridview..

SELECT dbo.Setup_article_production.article_id, dbo.Setup_article_production.article_code, dbo.Setup_article_production.article_name, dbo.Setup_article_production.machine_size, dbo.Setup_article_production.guage, dbo.Setup_article_production.gsm, dbo.Setup_article_production.weight, dbo.Setup_buyer.buyer_code FROM dbo.Setup_article_production LEFT JOIN dbo.Setup_buyer ON dbo.Setup_article_production.article_id = dbo.Setup_buyer.buyer_id