Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to get Primary Key Value if not Present in Foreign Key via Join? RE: How to get Primary Key Value if not Present in Foreign Key via Join?

  • May 4, 2014 at 1:11 pm

    #1710591

    eligiable (5/4/2014)

    It's just the SignedByUserID, that for Bilal Mateen does not exists in tblMer_Outlet, so we can change it to B.UserID from tblGen_Users, both are the same, but that not concern to me.

    The main thing I'm not getting the desired result in My Query.

    Good stuff, just wandered if you'd noticed. And then of course, you could also coalesce the count to a 0 and the month name.

    😎