SQL Server Performance Forum – Threads Archive
Query WritingHow to write a query , which will copy a data from one table to another ?
Without using inner join ????? Mr. Shailendra Thaware
Mobile No. 91-9890175282
I dont understand your question… You want to update some fields in table A, based on data in table B ?
Or do you want to insert rows from table B into table A? Im assuming its the first since you mention a JOIN, but what is your objection to using a JOIN ?
Could you be more specific?
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Why not use DTS. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
I Couldn’t Get Your Question? Wat exactly u want to ask ?
Sandy (DB Developer)
INSERT table1(col1, col2)
SELECT col1, col2 FROM table2 ????
[email protected] When life gives you a lemon, fire the DBA.
FROM t1 — Marek ‘chopeen’ Grzenkowicz, MCP