Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Server
SELECT Emp.EmpName,Emp.Empid,LeaveID,StartDate,EndDate,Reason,Status FROM Emp,Leave,ReportingAuthority Where (Emp.EmpID = Leave.EmpID) AND(Emp.AuthorityID =  ReportingAuthority.AuthorityID) AND(ReportingAuthority.LoginID='MBS1984')
the Answer:

dsvd    83  17  2013-02-07 00:00:00.000 2013-02-09 00:00:00.000 sick    NULL
dsvd    83  18  2013-02-08 00:00:00.000 2013-02-09 00:00:00.000     NULL
dsvd    83  18  2013-02-08 00:00:00.000 2013-02-09 00:00:00.000     NULL
dsvd    83  19  2013-02-08 00:00:00.000 2013-02-12 00:00:00.000 sick    NULL
dsvd    83  19  2013-02-08 00:00:00.000 2013-02-12 00:00:00.000 sick    NULL
Bala    82  16  2013-02-07 00:00:00.000 2013-02-09 00:00:00.000 sick    NULL
Bala    82  16  2013-02-07 00:00:00.000 2013-02-09 00:00:00.000 sick    NULL
 
executed more than once whta can i do.
Posted 30-Jan-13 0:48am
Edited 30-Jan-13 1:15am
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Check your join. You have one more common column between tables apart from empid and authorityid.Find it and add it to the where clause
  Permalink  
Comments
CHill60 at 30-Jan-13 6:26am
   
Or better yet - use JOIN ... ON to explicitly indicate which parts of the WHERE are just to join the tables
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

are you sure you do not have duplicate data? Also try to give schema of tables and FK relationship.
If you have duplicate data, you can use DISTINCT to get only distinct value.
 
http://www.w3schools.com/sql/sql_distinct.asp[^]
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 459
1 Maciej Los 325
2 Sergey Alexandrovich Kryukov 234
3 DamithSL 233
4 BillWoodruff 200
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100