Question about Microsoft SQL Server 2000 Standard Edition for PC
I had created one table n1 and another as n2 and i want to merge this two tables...
Means if exmple n1 have name, age, and designation and n2 have name, department and i want to make this two table into one as name, age,designation and department into single with query..
Someone help me to do this now only i am in beginner state..
Write a query student informatin and marks into the student pass or fail
Posted on Mar 13, 2008
"select n1.name,n1.age,n1.designation,n2.department into new_table
If you want to merge more than two tables you can use "INNER JOIN"
Consider table1 has name & id_no, table2 has id_no & salary, And table3 has id_no & Age.
If we want to merge like to crate a new table has name,age ,salary, Use the given Query
SELECT a.name,b.salary,c.age into newtable
FROM table1 a INNER JOIN table2 b ON a.id_no=b.id_no INNER JOIN table3 c
Posted on Dec 18, 2007
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 21, 2017 | Computers & Internet
on Sep 07, 2010 | Computers & Internet
Mar 11, 2015 | Oracle MySQL Enterprise Ed 1-4 Socket...
Jul 13, 2009 | Microsoft SQL Server 2005 Enterprise...
Jan 30, 2009 | Televison & Video
Dec 24, 2008 | Microsoft SQL Server 2005 Standard Edition
Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...
Aug 23, 2007 | Microsoft SQL Server Standard Edition for...
208 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: