Search results
-
A
SQL Query: Left join with two conditions behaving like an inner join.
I figured out a solution. In my left join, I changed the syntax to: This worked like a charm. Thank you everyone for the rubber ducking! -
A
SQL Query: Left join with two conditions behaving like an inner join.
That feels bizarre to me. Working in other SQL environments, this would join on rows where the field matched, and ignore/return null for the ones that did not. Isn't a left join supposed to return all rows from the left table? -
A
SQL Query: Left join with two conditions behaving like an inner join.
Fair point! I have a query that unions 3 tables. This part works pretty well, but I need to pull in a multivalue variable that exists in all three. My instinct was to then join my post-union dataset to the original three tables to only pull the multivalue variable from their respective tables... -
A
SQL Query: Left join with two conditions behaving like an inner join.
I did some searching before deciding to ask, but here is my issue. This is my entire query. A.Variable represents one of three categories, and when I include "A.Variable = 'Value'" my query only returns rows that contain this value. More context: Because of issues beyond my control, I have...