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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
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...
215 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: