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

Ali Khan

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

5 Replies

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

Rahul Singh8y ago
Create a View of Both Table
then insert data of Required fields.
+1
Ali Khan8y ago
first i use this "insert into article-production(code,name,weight)values(@code,@name,@weig‌ ht,(select buyer from setup where id =@id)" but it gives error then i use inserting into two different query for two different tables and wanted to see both table data in one select query but both tables not link or join and select query mention in question
0
Amit Gupta8y ago
Show your insert query and tell us more about your issue, in the question you used joins with select statement
+1
Ali Khan8y ago
both tables did not link/join
+1
Amit Gupta8y ago
You cannot save data to multiple tables When you use joins to fetch from multiple table.
0