Home Forums SQL Server 2008 SQL Server 2008 - General join 2 tables without duplicate rows RE: join 2 tables without duplicate rows

  • January 2, 2014 at 3:01 am

    #1676815

    Hi Guys, thanks for your help. I found simply adding distinct has done the trick

    Select distinct EPSAgedBalances.dbPatID, EPSAgedBalances.dbPatFirstName, EPSAgedBalances.dbPatLastName,

    EPSAllContracts.dbStaffLastName, EPSAgedBalances.TotTot

    from EPSAgedBalances, EPSAllContracts

    where EPSAllContracts.dbPatID = EPSAgedBalances.dbPatID

    and TotTot < 0

    thanks