> > ERROR: syntax error at or near "WHERE" > > LINE 10: WHERE o.total_price > ISNULL(sub.paid, 0);
> There error here is because a JOIN clause requires a join condition. Adding an > "ON true" is probably what you want. You would also need to change isnull() > with coalesce(). > The final query should be: ... ... ... > ) AS sub ON true ... ... OK - I see that it works now - which is great! However, it's unclear to me what, exactly, it is that is "TRUE"? What am I joining to what? The syntax is unclear to me - if I'm joining, I should be joining on tab_A.field_x = tab_B.field_y - no? Why does SQL Server's OUTER APPLY not require this? Thanks for any input - Merci, À+ Rgs, E.
