how to map two or more tables into one table in sql asp.net

Question

1.00/5 (2 votes)

See more:

how to map two or more tables into one table in sql asp.net

for example

table1=employee_details
employee_id emp_name emp_address status

table2= company_emplyee
emplyee_id Emp_salary location

output:Company_Name
employee_id emp_name emp_address Emp_salary location status

how to merge both the table into 1 single table filtering all data .

Posted 7-Jul-14 0:48am

10923679

Add a Solution

2 solutions

Solution 1

this might help you..

Datatable Merge [^]

SQL Joins[^]

Posted 7-Jul-14 1:02am

kedar001

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Zorro_ · Accepted Answer · 2014-07-07T01:03:00

Hi,

you could do something like this:

SQL

INSERT INTO Company_Name (
  employee_details.employee_id
  ,employee_details.emp_name
  ,employee_details.emp_address
  ,company_emplyee.Emp_salary
  ,company_emplyee.location
  ,employee_details.status)
SELECT
  employee_details.employee_id
  ,employee_details.emp_name
  ,employee_details.emp_address
  ,company_emplyee.Emp_salary
  ,company_emplyee.location
  ,employee_details.status
FROM 
  employee_details
  INNER JOIN company_emplyee ON
    company_emplyee.employee_id = employee_details.employee_id

how to map two or more tables into one table in sql asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to map two or more tables into one table in sql asp.net

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us