Is there a way to do what I want to call a "LEFT CROSS JOIN"?
I.e., is there a way to specify a CROSS JOIN ON, but return at least one row in the result for every row in the left, using nulls for the right-side columns when the right-side table does not contain a match?
Asked by Joshua Goldberg
(227 rep)
Dec 16, 2021, 04:45 PM
Last activity: Dec 22, 2021, 08:44 PM
Last activity: Dec 22, 2021, 08:44 PM