我想要一个查询,在我的情况下,table1和表2有不同的结构,但id是公共字段,我想要的是找到显示table1和table2数据的方法。On ==> id table1 = id table2 into table1
例如dbo。Personal_details具有Emp_ID和dbo。具有相同列Emp_ID的员工。我想合并Emp_ID值到dbo.Personla_details.
Personal_details: Employees:
Emp_id Emp_ID
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9
.
.
upto 550 records in this table
所以,我想合并员工的Emp_ID到Personal_Details的Emp_ID。如何合并细节
请帮帮我,
提前感谢,
Naresh .
希望对您有所帮助....
MERGE <target_table> [AS TARGET]
USING <table_source> [AS SOURCE]
ON <search_condition>
[WHEN MATCHED
THEN <merge_matched> ]
[WHEN NOT MATCHED [BY TARGET]
THEN <merge_not_matched> ]
[WHEN NOT MATCHED BY SOURCE
THEN <merge_ matched> ];