Re: Joins not joining

Hi! Thanks for the information. If possible could you share your test case (including SQL and configurations) so that we can look deeper into this problem? Curt Buechter 于2021年11月15日周一 上午9:45写道： > Thanks for the response. But, no, that's not the scenario. I'm familiar > with later arriving data

Re: Joins not joining

Thanks for the response. But, no, that's not the scenario. I'm familiar with later arriving data. In my case, though, the record on table 2 never arrives. I'm not positive, but it may only be happening when there are three or more tables being joined in one statement. On Sun, Nov 14, 2021, 7:32 PM

Re: Joins not joining

Hi! sometimes it produces a result, and sometimes it doesn't Do you mean this scenario: Consider a record from table1 with a.bId = 1. You know that in table2 there is a record with b.Id = 1, but the join result is null at the beginning, and then it is updated with the correct result? This is th

Joins not joining

Hi, I'd like to understand a little more how joins work. I have a fairly simple LEFT JOIN query, and I'm seeing spotty results on the joins. I know there is a record on the right side, but sometimes it produces a result, and sometimes it doesn't. Sample query: SELECT a.id, b.val1, c.val2 FROM tabl