How to eliminate NULL fields in TSQL
- by salvationishere
I am developing a TSQL query in SSMS 2008 R2. I am trying to develop this query to identify one record / client. Because some of these values are NULL, I am currently doing LEFT JOINS on most of the tables. But the problem with the LEFT JOINs is that now I get 1 record for some clients.
But if I change this to INNER JOINs then some clients…