Jump to content

raghugnair

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About raghugnair

  • Rank
    Newbie
  1. txs for the reply, i know how to find the duplicate from one table. what i want is, to display the duplicate records from a join table result.
  2. Hi all, I want to find duplicate records from a joint table result (The two tables are from two different DB's). Bellow are the tables and my requirement. Table1 from DB D1EmpID205205205206207207208209210211 Table2 from DB D2PayID205206207 208 209 210 211 i have joined these two tables on the basis of EmpID = PAYID and got the following result SELECT T1.EMPID,T2.PAYIDFROM D1.table1 T1INNERJOIN D2.table2 T2 onT1.EMPID collate Latin1_General_CI_AI =T2.PayID EmpID PayID 205 205 205 205 205 205206 206207 207207 207208 208209 209210 210211 211 In this result 205 and 207 having duplicate, so i want a query to display the duplicate entries .
×
×
  • Create New...