SQLServerCentral » Latest topics
Left Join not returning all rows from left table
I am stuck as to why the query is not returning all rows. My CTE1 has 92 rows and CTE2 has 90 rows.
My query should return 92 rows - but I am getting 90.
Thanks
with CTE1 (EmpID,Name,SSN,GrossPay,PayRate,Birthdate,Hiredate,Stre
My query should return 92 rows - but I am getting 90.
Thanks
with CTE1 (EmpID,Name,SSN,GrossPay,PayRate,Birthdate,Hiredate,Stre
No comments:
Post a Comment