Sample Header Ad - 728x90

Is there such a thing as a LEFT CROSS JOIN?

5 votes
2 answers
9656 views
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