Home Forums SQL Server 2005 Development Self Join Brings Too Many Records RE: Self Join Brings Too Many Records
John Mitchell-245523
SSC Guru
Points: 148809
More actions
March 22, 2013 at 10:54 am
#1599882
Table DDL, sample data and expected results would help us to help you. In the absence of that, what does this return?
SELECT DISTINCT rep_id, hcp_cid
FROM SE_Violation_Detection
John