Recent content by millhouse123

My inner query returns 102 results but my outter query only returns 96. The records that are null on the right side are he ones not showing up in my query. Sorry I can't post the database but I am more than happy to answer any questions so that I can get this figured out. Thanks so much for...

is this what you mean? This still does not work for me? Select distinct a.entity,a.gl_account,a.profit_center from( SELECT DISTINCT [Open Items].entity, [Open Items].gl_account, [Open Items].profit_center FROM [Open Items] )a LEFT JOIN [Open Items] AS [Open Items_1] ON...

So how do you limit your results if you can't have a where statement when left joining? I want all records from left table even if there is no match in right table but also want to limit records from right table to a specific date?

I have a simple nested query that is not working as expected. My inner query returns 102 records but when I run with outer query I only get 96 records. Below is my query, I don't really want to pull the same fields from both tables but I was doing to test. The values that are missing are those...