hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

Explain indexed views?

0 Answers  

---

Can you leave a union at any time?

0 Answers  

---

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,

---

---

How to rebuild all indexes on a single table?

0 Answers  

---

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

What is dirty page?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

What are the advantages of having an index on the sql server?

0 Answers  

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---