Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help With WHERE Statement RE: Help With WHERE Statement

  • March 30, 2014 at 11:03 pm

    #1701463

    Quick note, be careful not to use reserved keywords in this manner, that is the alias for INSPECTION being IS.

    SELECT INS.INSPNO, CNT.FIRSTNAME, CNT.LASTNAME

    FROM INSPECTION INS

    INNER JOIN INSPECTIONCONTACT CNT

    ON INS.INSPNO = CNT.INSPNO

    WHERE CNT.CAPACITY <> 'Contractor'

    😎

    Thanks for the tip; however, I'm actually using completely different alias all together. I just tried to simplify this to make it easy for y'all to help. With that being said, any suggestions on how to accomplish what I'm trying to accomplish?

    Thanks,

    Jordon