Query join probs..,

[Member 3879881]

Hi this is my query: SELECT EM.empId, TC.carddate,SD.Whrs, MHD.Appwhours as AppHours,MHD.AppOtHours as AppOtHours FROM dbo.tblEmployeeMaster EM INNER JOIN dbo.tblTimeCardmain TC ON EM.empId = TC.empid INNER JOIN dbo.tblSalaryDetails SD ON EM.empId = SD.EmpID left outer join dbo.tblMonthHourdetails MHD ON TC.empid=MHD.empid and TC.Carddate=MHD.Sdate WHERE TC.carddate = '8/1/2007' AND TC.app1 = 1 AND TC.projectid = 100 order by EM.Empid For this i am getting o/p like: Empid carddate whrs AppHours AppOtHours 100 8/1/2007 11 11 3 101 8/1/2007 8 8 6 102 8/1/2007 11 11 3 103 8/1/2007 11 11 3 103 8/1/2007 11 11 3 See that empid=103 have 2 entries in tblsalarydetails..., So its givng in o/p 2 values..., But there i need one o/p that want to be based on the date..., In my tblsalarydetails i have date column..., So How to display the whrs based on the date for that employee?, Plz hlp me..., Tblsalarydetails table design: empid whrs edate 100 11 8/1/2007 101 8 7/1/2007 102 11 8/1/2007 103 11 8/1/2007 103 10 2/21/2007

Regards, Magi

[T EDY]

Magh_M wrote:

See that empid=103 have 2 entries in tblsalarydetails..., So its givng in o/p 2 values..., But there i need one o/p that want to be based on the date...,

if u want only one output each empid..why dont u use Select Distinct query

Regards, Tomi

[Edwin Syarief]

SELECT DISTINCT your_column FROM bla... bla... bla...

I hope this will help U

Regard, Edwin